sp_helpdb
select d.name
from master..sysdatabases d, master..sysprocesses p
where d.dbid=p.dbid and p.spid=@@spid
SELECT * FROM sysobjects WHERE type = 'U'
SELECT sc.*
FROM syscolumns sc
INNER JOIN sysobjects so ON sc.id = so.id
WHERE so.name = 'my_table_name'
Thanks to Lukasz Lysik's post on StackOverflow
IF EXISTS (SELECT name FROM sysdatabases WHERE name = 'testdb')
BEGIN
EXECUTE('DROP DATABASE testdb')
print '[testdb] dropped'
END