You can retrieve the value of a specific database property or the values of all database properties. Database properties apply to an entire database.
For descriptions of all of the database properties, see SQL Anywhere Server - Database Administration > Configuring your database > Connection, database, and database server properties > Database server properties. The server properties QueryBypassedCosted, QueryBypassedOptimized, QueryDescribedOptimizer, and StatementPostAnnotatesSimple are updated only for queries against SQL Anywhere tables.
Use the db_property system function to retrieve the value of a database property. The following statement returns the page size of the current database:
select db_property ( 'PageSize')
Use the sa_db_properties system procedure to retrieve the values of all database properties:
call sa_db_properties