sa_db_properties( [ dbidparm ] )

If you specify a database ID, the sa_db_properties system procedure returns the database ID number and the PropNum, PropName, PropDescription, and Value for each available database property. Values are returned for all database properties and statistics related to databases. Valid properties with NULL values are also returned.

If dbidparm is not specified, properties for all databases are returned.

Cloud note: Because of tenant database isolation rules, when this system procedure is run in the cloud it returns only information about the current tenant database.

None

None

• sa_db_info system procedure
• Accessing database property values

The following example uses the sa_db_properties system procedure to return a result set summarizing database property information for all databases.

CALL sa_db_properties( );