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 the section “Database properties” in the chapter “Database Performance and Connection Properties” in the Adaptive Server Anywhere Database Administration Guide
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
