Tuesday, February 3, 2009

To get Table names from a particular Database

Execute below query on a particular Database.

select table_name from Information_Schema.Tables where Table_Type='Base Table'

which gives all the table names.

Here the where condition is for excluding "Views" from the result set.

No comments:

Post a Comment