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'
Join the conversation! Your thoughts help the community grow.