Reports database property information.
sa_db_info ( [ database-id ] )
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
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. Table 7-73 lists sample values.
sa_db_info
0,'iqdemo',' /sys1/users/test/sybase/IQ-15_1/demo/iqdemo.db', 1,4096,'/sys1/users/test/sybase/IQ-15_1/demo/iqdemo.log'
Property |
Value |
|---|---|
Number |
0 |
Alias |
iqdemo |
File |
C:\Documents and Settings\All Users\SybaseIQ\demo\iqdemo.db |
ConnCount |
1 |
PageSize |
4096 |
LogName |
C:\Documents and Settings\All Users\SybaseIQ\demo\iqdemo.log |
