IF EXISTS(SELECT name FROM test..sysobjects WHERE name = N'person' AND xtype='U')
DROP TABLE person
go
test:数据库名
person:表名
IF EXISTS(SELECT name FROM test..sysobjects WHERE name = N'person' AND xtype='U')
DROP TABLE person
go
test:数据库名
person:表名