Thank you.
>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'
>>>