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: 1809 | Points: 40

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

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

Here,U is User Table.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response