INFORMATION_SCHEMA Information

I can use queries to retreive many informations from INFORMATION_SCHEMA
SELECT * FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME = 'tablename'
But I want to know how to find where that table exists as it is not
part of sysobjects
MadhivananThe Information Schema consists of views, which you can find in the Master
database.
David Portas
SQL Server MVP
--sql