Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Reference » System Objects » System procedures » Alphabetical list of system procedures

 

sa_table_page_usage system procedure

Reports information about the page usage of database tables.

Syntax
sa_table_page_usage( )
Result set
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.
Remarks

The results include the same information provided by the Information utility.

Permissions

DBA authority required

Side effects

None

See also