use pubs go if object_id('jobs') is not null print 'jobs table exists' else print 'jobs table does not exist' go --- jobs table exists