Sybase Adaptive Server Anywhere - Page 985

Chapter 14 System Procedures and Functions
967
$ For a listing of available connection properties, see "System
functions
" on page 310sa_db_info system procedure
Reports database property information
sa_db_info ( [ database-id ] )
None.
None
"sa_db_properties system procedure" on page 967
"Database-level properties" on page 1101
Returns a single row containing the Number, Alias, File, ConnCount,
PageSize, and LogName for the specified database.
♦ 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:\asa6\asademo.db
ConnCount 1
PageSize 1024
LogName c:\asa6\asademo.log
sa_db_properties system procedure
Reports database property information
sa_db_properties ( [ database-id ] )
None.
None
"" on page 310sa_db_info system procedure" on page 967
"Database-level properties" on page 1101
Function
Syntax
Permissions
Side effects
See also
Description
Examples
Function
Syntax
Permissions
Side effects
See also