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.

• sp_help Usage on Database Objects
  Use sp_help to display information about a specified database object (that is, any object listed in sysobjects), a specified datatype (listed in systypes), or all objects and datatypes in the current database.
• Use sp_helpconstraint to Find Table Constraint Information
  sp_helpconstraint reports information about the declarative referential integrity constraints that are specified for a table, including the constraint name and definition of the default, unique or primary key constraint, referential, or check constraint.
• Determining Much Space a Table Uses
  sp_spaceused computes and displays the number of rows and data pages used by a table or a clustered or nonclustered index.
• List Tables, Columns, and Datatypes
  Catalog stored procedures retrieve information from the system tables in tabular form. You can supply wildcard characters for some parameters.
• Find an Object Name and ID
  To identify the ID and name of an object, use object_id() and object_name().