| Below is the query to check that if table exists or not. To check this we need to check this in Information Schema tables.
IF (EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'Table_Schema'
AND TABLE_NAME = 'Table_Name'))
BEGIN
--Do Stuff any statements
END
| | |