2007/9/11更新

対応バージョン: 11.9.2

sysdatabasesシステムテーブルを参照するか、sp_helpdbを実行する。

1> select name,dbid,crdate,dumptrdate from sysdatabases
2> go
 name           dbid crdate              dumptrdate
 -------------- ---- ------------------- -------------------
 master            1 Jan  1 1900 12:00AM Mar  1 2002  6:12PM
 model             3 Jan  1 1900 12:00AM Mar  1 2002  6:13PM
 sybsystemprocs    4 Mar  1 2002  6:11PM Mar  1 2002  6:13PM
 tempdb            2 Mar  1 2002  6:11PM Mar  4 2002  1:51PM
 :

1> sp_helpdb
2> go
 name           db_size owner dbid created      status
 -------------- ------- ----- ---- ------------ ----------------------------
 master          5.0 MB sa       1 Jan 01, 1900 no options set
 model           2.0 MB sa       3 Jan 01, 1900 no options set
 sybsystemprocs 60.0 MB sa       4 Mar 01, 2002 no options set
 tempdb          2.0 MB sa       2 Mar 06, 2002 select into/bulkcopy/pllsort
 :