Query to get all table names

Question

Can any one tell me that how to get names of all tables of a database using asp.net

Answer 1

You didn't mention which database engine you are using. On SQL Server, you can query the sysobjects table and filter for objects with type U:

SELECT name FROM sysobjects WHERE type = 'U'

Answer 2

A newer method on SQL Server is to use the INFORMATION_SCHEMA Views to get the information:

SELECT table_name FROM INFORMATION_SCHEMA.Tables WHERE table_type='BASE TABLE'

This particular view also includes Views in its list of tables, which is why you need the where clause.

Answer 3

In case you are interested in the MySQL way to achieve this, you can use

DESCRIBE tableName;