IF EXISTS(SELECT * FROM tempdb..sysobjecTs where [name] LIKE ‘%tablename%’)
PRINT ‘EXISTS!’

Advertisements