7 September 2012

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'