![DB_NAME function [System]](arrow-left.gif){kind=icon}
![DEGREES function [Numeric]](arrow-right.gif){kind=icon}
Returns the value of the given property.
DB_PROPERTY ( { property-id | property-name }
[ , { database-id | database-name } ] )
CIS functional compensation performance considerations
apply. See “Conditions
that cause processing by SQL Anywhere” in Chapter
3, “Optimizing Queries and Deletions,” in
the Performance and Tuning Guide.
property-id The database property ID.
property-name The database property name.
database-id The database ID number, as returned by DB_ID. Typically, the database name is used.
database-name The name of the database, as returned by DB_NAME.
The following statement returns the page size of the current database, in bytes.
SELECT DB_PROPERTY( 'PAGESIZE' ) FROM iq_dummy
Returns a string. The current database is used if the second argument is omitted.
