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

Madhivanan

The Information Schema consists of views, which you can find in the Master
database.

Error converting data type nvarchar to int.
move records from table1 to table2 if does not exist in table3
Query Help
FIFO report
Performance Issues using Aggregate MAX function within a temp table