List alll tables from a database

satheesh d4y ago

We can able to list all the tables from an particular database using SQL Query.

Select * from sysobjects

This will return all the object that are present in a particular database(table, stored procedure, views, functions).
In order to retrieve only the tables from a particular database , then we can filter the query by using XTYPE='U'. Here U means user table.

Select * from sysobjects Where xtype='U'

The alternate way to list all the tables from the database,

Select * from sys.tables

+2

tejal bhesaniya14y ago

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

+3