SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME =
‘table Name’ AND TABLE_TYPE = ‘BASE TABLE’
June 10, 2008...9:34 am
SQL Query to check whether a table exists or not in a database
Jump to Comments
2 Comments
December 4, 2008 at 4:43 pm
SUPER AND SIMPLY FANTASTIC
I GOT EXACT ANSWER WHAT I EXPECTED , THANK U VERY MUCH
GOOD GOING
January 16, 2009 at 12:20 pm
Nice