sa_table_page_usage system procedure

sa_table_page_usage( )

Column name	Data type	Description
TableId	UNSIGNED INTEGER	The table ID.
TablePages	INTEGER	The number of table pages used by the table.
PctUsedT	INTEGER	The percentage of used table page space.
IndexPages	INTEGER	The number of index pages used by the table.
PctUsedI	INTEGER	The percentage of used index page space.
PctOfFile	INTEGER	The percentage of the total database file the table occupies.
TableName	CHAR(128)	The table name.

The results include the same information provided by the Information utility. When the progress_messages database option is set to Raw or Formatted, this procedure periodically sends progress messages while it is running.

DBA authority

None

sa_table_page_usage system procedure

Syntax

Result set

Remarks

Permissions

Side effects

See also