Properties available for each database

Database properties apply to an entire database. This section describes how to retrieve the value of a specific database property or the values of all database properties. For descriptions of all of the database properties, see "Database server properties" in SQL Anywhere Server – Database Administration.

Examples

StepsRetrieving the value of a database property

  1. Use the db_property system function. The following statement returns the page size of the current database:

select db_property ( 'PageSize') from iq_dummy

StepsRetrieving the values of all database properties

  1. Use the sa_db_properties system procedure:

call sa_db_properties