已下是一个测试表:if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[test_data]) and OBJECTPROPERTY(id, NIsUserTable) = 1)drop table [dbo].[test_data]GOCREATE TABLE [dbo].[test_data]
摘要由CSDN通过智能技术生成
已下是一个测试表:
ifexists (select*from dbo.sysobjects where id =object_id(N'[dbo].[test_data]') andOBJECTPROPERTY(id, N'IsUserTable') =1) droptable[dbo].[test_data] GO
已下是一个测试表:if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[test_data]) and OBJECTPROPERTY(id, NIsUserTable) = 1)drop table [dbo].[test_data]GOCREATE TABLE [dbo].[test_data]