Click here to hide categories Click here to show left categories

User: Home          welcome : Guest          Log In / Register here     




Get the list of all tables of a database

In sql server 2005, We can get the list of tables from the Sys.Tables from a database. With the below query we can get the list of all tables in a database.


SELECT * FROM sys.Tables

With below query we may find the list of Views also with the tables.

SELECT * FROM information_schema.Tables

Share this article   |    Print    |    Article read by 1279 times
Author:
Rohit kakria
I am software developer, moderator of xpode.com
Related Articles:
Related Interview Questions: