Sybase: what device names does a database use?

Does anyone know how I can query the database to find what devices a开发者_C百科 database uses?

There is the sysdatabases table and the sysdevices table but I don't know how to link them

Anyone know?

The best way is to run sp_helpdb against the database you're interested in:

1> sp_helpdb tempdb2
2> go
... other stuff here...
device_fragments               size          usage                created                   free     kbytes
------------------------------ ------------- -------------------- ------------------------- ----------------
tempdb2data                        2048.0 MB data only            Dec 17 2008 11:42AM                2086568
tempdb2log                         2048.0 MB log only             Dec 17 2008 11:42AM       not applicable
tempdb2log                         2048.0 MB log only             Dec 17 2008 11:42AM       not applicable
tempdb2data                        2048.0 MB data only            Dec 17 2008 11:43AM                2088960
tempdb2log                         4096.0 MB log only             Dec 17 2008 11:44AM       not applicable

--------------------------------------------------------------
log only free kbytes = 8355836

1 Just a note re your first question. If you USE database first, you will get even more detail in the report.

2 Do you still need the second question answered, how to link sysdatabase and sysdevices, as in, are you writing queries against the catalogue ? If so, I need your ASE version, the answers are different.