How to check whether Table is present or not in the Database?

 Posted by vishalneeraj-24503 on 7/2/2014 | Category: Sql Server Interview questions | Views: 641 | Points: 40
Answer:

We will write below query to check Table presence:-
If Object_Id('Table_Name','U') Is Not Null

Print 'Table Exists';
Else
Print 'Table does not Exists';

Here,U is User Table.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response