0
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[YourTable]')
if it exist then it will display the result,,,with table name ,,,tpe and everything
0
Select your database and open new query window and
EXEC sp_tables @table_type = "'table'"
0
hi,
there are two tables sys.tables and sys.objects, in which data base maintain table information
please try.
select * from sys.tables where name = 'Table1'
select * from sys.objects where type = 'U' and type_desc = 'USER_TABLE'
hope this will help you.