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


##</code><code>##

use pubs
go
if exists(select 1 from information_schema.tables where table_name = 'jobs')
	print 'jobs table exists'
else
	print 'jobs table does not exist'
go