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. The server properties QueryBypassedCosted, QueryBypassedOptimized, QueryDescribedOptimizer, and StatementPostAnnotatesSimple are updated only for queries against SQL Anywhere tables.
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