top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

How to Check existence of any table using PL-SQL in SQL server 2008?

0 votes
52 views
How to Check existence of any table using PL-SQL in SQL server 2008?
posted Mar 19, 2016 by Sathyasree

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

In SQL server 2008 we can check existence of any table by its name using If Exist function and after that we can perform any operation based on result of if exist function. It is very simple to implement in PL-SQL

Query:

IF EXISTS (SELECT * FROM sys.objects WHERE object_id =OBJECT_ID(N'[dbo].[Users]') AND type in (N'U'))

BEGIN

Drop table Users 

END

In this query we are checking table existence before dropping it.

We can also check other way around in this query it is also very much simple

Query:

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id =OBJECT_ID(N'[dbo].[Login]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[Login](

      [UserID] [varchar](50) NOT NULL,

      [Password] [varchar](20) NULL,

      [Type] [varchar](20) NULL,

PRIMARY KEY CLUSTERED

(

      [UserID] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

END
answer Mar 19, 2016 by Shivaranjini
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...