System tables contain information about the objects defined in the current database.
The following table provides an overview of the SAP ASE system tables.
| Name | Description |
|---|---|
| syscolumns | Provides information about table and view columns, including column name, data type, length, default values, and computed column definitions. |
| sysconstraints | Provides information about table constraints such as CHECK constraints, referential constraints, rules, and other integrity constraints. |
| sysdatabases | Provides information about databases on the SAP ASE server. |
| sysindexes | Provides information about indexes and table storage structures, including clustered and nonclustered indexes and tables that contain text or image columns. |
| syskeys | Provides information about keys associated with indexes, including the columns that make up each index key. |
| sysobjects | Provides information about every object in the database such as tables, views, stored procedures, triggers, and constraints. |
| sysprocedures | Provides information about the source text and metadata for stored procedures created in the database. |
| sysreferences | Provides information about foreign key relationships between tables. |
| syssequences | Provides information about sequence objects used to generate sequential numeric values. |
| systypes | Provides information about all system and user-defined data types available in the database. |