List alll tables from a database

Question

Hi all I want to find whether a table exists in a database. I have only the database name and table name. Can anyone please tell me how to list all tables in a database so that I can find whether the table is present in the database? Regards

tejal bhesaniya · Answer

SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[YourTable]') if it exist then it will display the resultwith table name tpe and everything

Naresh Avari · Answer

Select your database and open new query window and EXEC sp_tables @table_type = 'table'

Jignesh Trivedi · Answer

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.