Contents Index DB_EXTENDED_PROPERTY function [System] DEGREES function [Numeric]

ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

DB_PROPERTY function [System]


Function 

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 DB_ID. Typically, the database name is used.

database_name    The name of the database, as returned by DB_NAME.

Usage 

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

Standards and compatibility 
See also 

DB_ID function [System]

DB_NAME function [System]

Database-level properties

Example 

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

SELECT DB_PROPERTY( 'PAGESIZE' )

Contents Index DB_EXTENDED_PROPERTY function [System] DEGREES function [Numeric]