>>IF EXISTS (SELECT * FROM pubs.INFORMATION_SCHEMA.TABLES
>>         WHERE table_name = 'authors' AND table_type = 'BASE TABLE')
>>  -- Table exists
>>...
>>