Returns the value of the given property.
DB_PROPERTY( { property-id | property-name } [, database-id | database-name ] )
property-id The database property ID.
property-name The database property name.
database-id The database ID number, as returned by the DB_ID function. Typically, the database name is used.
database-name The name of the database, as returned by the DB_NAME function.
VARCHAR
Returns a string. The current database is used if the second argument is omitted.
SQL/2003 Vendor extension.
The following statement returns the page size of the current database, in bytes.
SELECT DB_PROPERTY( 'PageSize' ); |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |