–判断当前数据库是否存在某个表,有则删除后再新建
If Exists (select * from sysobjects where id = object_id(‘N’YourTable’)
and OBJECTPROPERTY(id, ‘IsUserTable’) = 1)
Drop Table YourTable
Else
Begin
CREATE TABLE YourTable
End
或者
IF OBJECT_ID(N’YourTable’,N’U’) IS NOT NULL
DROP TABLE YourTable
ELSE
Begin
CREATE TABLE YourTable
End
–判断是否存在临时表
IF EXISTS (SELECT *
FROM tempdb.dbo.sysobjects
WHERE ID = OBJECT_ID(N’tempdb…##临时表名’))
BEGIN
DELETE FROM ##临时表名
DROP TABLE ##临时表名
END