DB_PROPERTY function [System]

Returns the value of the given property.

Syntax
DB_PROPERTY( 
{  property-id  |  property-name  }
[, database-id | database-name ] 
)
Parameters
  • 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.

Returns

VARCHAR

Remarks

Returns a string. The current database is used if the second argument is omitted.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

The following statement returns the page size of the current database, in bytes.

SELECT DB_PROPERTY( 'PageSize' );