Sybase db_id function
Tested On: Sybase Version 11.9.2 and 15.0
| Code | Output |
|---|---|
| select db_id("master") | 1 |
| select db_id("tempdb") | 2 |
| select db_id("model") | 3 |
| select db_id("sybsystemprocs") | 4 |
| select db_id("Master") | NULL |
| select db_id("MASTER") | NULL |
This information can also be obtained from the system tables
select dbid, name from master..sysdatabases order by dbid
|
Roger Hall COMPUSPEC |
|