List All Tables of Database Using SQL Query

In this blog we will see how to list all tables of a database using SQL Query.

Write the following query and execute.

SELECT* FROM sys.Tables

There is another query that we can use to achieve the same.

Write the following query.

SELECT*FROMinformation_schema.tables

Wel, there is one more way by which we can list all the tables in a database. Write the following query in the query analyzer.

SELECT sobjects.name FROM sysobjectssobjects WHERE sobjects.xtype='U'