Reports information about the page usage of database tables.
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, progress messages are sent from the database server to the client while the sa_table_page_usage system procedure is running.
You must have the MANAGE ANY DBSPACE system privilege.
None
The following example obtains information about the page usage of the SalesOrderItems table.
SELECT * FROM sa_table_page_usage( )
WHERE TableName = 'SalesOrderItems';