Retrieve Information About Databases and Tables

SAP ASE includes several procedures and functions you can use to get information about databases, tables, and other database objects.

See the Reference Manual: Procedures and also the Reference Manual: Building Blocks for information about the procedures and functions for additional information.

• Help on Databases
  sp_helpdb can report information about a specified database or about all SAP ASE databases.
• Help on Database Objects
  SAP ASE provides system procedures, catalog stored procedures, and built-in functions that return helpful information about database objects, such as tables, columns, and constraints.