The following are queries to check the object / table exist or not before create / drop in Sql Server.
IF OBJECT_ID('dbo.temp_data') IS NOT NULL
BEGIN
execute (N'DROP TABLE [dbo].[temp_data]')
END
IF OBJECT_ID('dbo.temp_data') IS NULL
BEGIN
CREATE TABLE [dbo].[temp_data](
[no] [int] NULL,
[empname] [varchar)100)] NULL,
[empDept] [varchar(100)] NULL,
[empLocation] [varchar(100)] NULL
) ON [PRIMARY]
END
IF OBJECT_ID('dbo.temp_data') IS NOT NULL
BEGIN
execute (N'DROP TABLE [dbo].[temp_data]')
END
IF OBJECT_ID('dbo.temp_data') IS NULL
BEGIN
CREATE TABLE [dbo].[temp_data](
[no] [int] NULL,
[empname] [varchar)100)] NULL,
[empDept] [varchar(100)] NULL,
[empLocation] [varchar(100)] NULL
) ON [PRIMARY]
END
No comments:
Post a Comment