SQL判断数据库是否存在。

IF EXISTS(SELECT * FROM SYSDATABASES WHERE NAME = '你要判断的数据名字')

PRINT '存在'

ELSE

PRINT '不存在'

1.数据库

if exists(select 1 from master..dbo.sysdatabases where name='example')

print 'DataBase existed'

else

print 'Database not existed'

2.表

IF Exists(Select 1 From sysObjects Where Name ='表名' And Type In ('S','U'))

Print 'Exists Table'

Else

Print 'Not Exists Table'

---