Accessing database property values

Database properties are available for each database on the database server. You can use the DB_PROPERTY system function to retrieve the value for an individual property, or you can use the sa_db_properties system procedure to retrieve the values of all database properties. Property names are case insensitive.

 Retrieve the value of a database property
  • Use the DB_PROPERTY system function. For example, the following statement returns the page size of the current database:

    SELECT DB_PROPERTY ( 'PageSize' );
 Retrieve the values of all database properties
  • Use the sa_db_properties system procedure:

    CALL sa_db_properties;
 See also
 Database properties