Sure
IF EXISTS (SELECT * FROM pubs.INFORMATION_SCHEMA.TABLES
WHERE table_name = 'authors' AND table_type = 'BASE TABLE')
...
>I have a question about the INFORMATION_SCHEMA view.
>
>I query the sysobjects to be sure that the table is in the db, will INFORMATION_SCHEMA allow me to do the same thing?
>
>I can't do a search at this time, other wise I would not be bothering you.
>
>Hope you're having a good day. :-)
>
>Beth
>
>>It's better to use INFORMATION_SCHEMA views than query system tables directly
SELECT * FROM
>> pubs.INFORMATION_SCHEMA.COLUMNS
>>WHERE table_name = 'authors'
>>
--sb--