ASA SQL Reference
  System Procedures and Functions
    System and catalog stored procedures

sa_db_info system procedure

Function 

Reports database property information.

Syntax 

sa_db_info ( [ database-id ] )

Permissions 

None

Side effects 

None

See also 

sa_db_properties system procedure

Database-level properties

Description 

Returns a single row containing the Number, Alias, File, ConnCount, PageSize, and LogName for the specified database.

Example 

• The following statement returns a single row describing the current database:

  CALL sa_db_info

  Sample values are as follows:

  Property	Value
  Number	0
  Alias	asademo
  File	C:\program files\Sybase\SQL Anywhere 9\asademo.db
  ConnCount	1
  PageSize	1024
  LogName	C:\program files\Sybase\SQL Anywhere 9\asademo.log