Reports database property information.
sa_db_info ( [ database-id ] )
None.
“sa_db_properties system 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 10-54 lists sample values.
sa_db_info
0,'asiqdemo',' /sys1/users/janed/sybase/ASIQ-12_7/demo/asiqdemo.db', 1,4096,'/sys1/users/janed/sybase/ASIQ-12_7/demo/asiqdemo.log'
Property |
Value |
|---|---|
Number |
0 |
Alias |
asiqdemo |
File |
c:\ASIQ-12_7\demo\asiqdemo.db |
ConnCount |
1 |
PageSize |
4096 |
LogName |
c:\ASIQ-12_7\demo\asiqdemo.log |
