List All Tables of Database Using SQL Query

Write the following query and execute.

  1. SELECTFROM sys.Tables  

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

Write the following query.
  1. SELECT*FROMinformation_schema.tables  
run query

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.
  1. SELECT FROM sysobjectssobjects WHERE sobjects.xtype='U'