How to Check Particulat Table is Exist / Not in Database if EXISTS (select * from [DBName].INFORMATION_SCHEMA.TABLES where table_name = 'tablename') Select 'Table found' ELSE SELECT 'TABLE NOT FOUND' Share This: Facebook Twitter Google+ Stumble Digg