Getting Information About Segments

SAP ASE includes a number of system procedures that provide information about segments.

• sp_helpsegment
  sp_helpsegment, when used without an argument, displays information about all of the segments in the database from which you execute it.
• sp_helpdb
  Execute sp_helpdb within a database, and specify the database's name to see information about the segments in the database.
• sp_help and sp_helpindex
  Execute sp_help and sp_helpindex in a database, and specify a table’s name to see information about which segments store the table or its indexes.