|Article Time Stamp: 02 April 2012, 22:46:28 GMT+7|
Microsoft SQL (MS SQL): Sample SQL Script to Check If A Table Exists
Let's say, that we want to check whether a table already exists in our database or not. We named our table as tbl_a. And if it doesn't exists, then we just print to the screen 'Not Exists' words. Otherwise, we just print 'Already Exists' words.
Or you can also use this SQL statements: