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.
Retrieving the value of a database property
Use the db_property system function. The following statement returns the page size of the current database:
select db_property ( 'PageSize') from iq_dummy
Retrieving the values of all database properties
Use the sa_db_properties system procedure:
call sa_db_properties
