How to get list of table names in Sql Database

Below code show you how to get list of table names in selected SQL database.

SQL Code

Select         TABLE_CATALOG,TABLE_NAME

From          INFORMATION_SCHEMA.TABLES

Where        TABLE_TYPE = 'BASE TABLE'

Order by    Table_Name

Try it copy & Paste on SQL Query  analyzer

Code Description

1. From          INFORMATION_SCHEMA.TABLES            -  Table name in SQL master table

2. Select         TABLE_CATALOG,TABLE_NAME               -  Field name in Information Table

3. Where        TABLE_TYPE = 'BASE TABLE'                     -  Find Table Type 'Base Table'
4. Order by    Table_Name                                                     -  Order Field by Table name