CREATE PROCEDURE p_pp
if exists (select * from sysobjects where id = object_id(N'[dbo].[t_bxd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_bxd]
我用这个后 出现IF语句错误
if exists (select * from sysobjects where id = object_id(N'[dbo].[t_bxd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_bxd]
我用这个后 出现IF语句错误
as
if exists (select * from sysobjects where id = object_id(N'[dbo].[t_bxd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_bxd]
drop table 表名
...
as
if exists (select * from sysobjects where id = object_id(N'[dbo].[t_bxd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_bxd]
DROP TABLE TB
drop table 表名