if table exists in sql drop it and then create by using OBJECT_ID()

if object_id('#temptablename') is not null drop tableĀ  #temptablename
create tableĀ  #temptablename
(
EmpCode nvarchar(200) primary key,
BillAmount numeric(18,2)
)

 

OR

 

IF EXISTS (Select * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tablename]') AND type in (N'U'))
Begin
DROP TABLE [dbo].[tablename]
End
ELSE
Begin
Create Table tablename
(EmpCode nvarchar(20) primary key,BillAmount int)
End

 

 

Advertisements
This entry was posted in Sql. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s