aspdotnet-suresh offers articles and tutorials,csharp dot net, articles and tutorials,VB.NET Articles,Gridview articles,code examples of 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

SQL Server - Query to Get List of Tables in Database in SQL Server 2008

Dec 9, 2013

Here I will explain
SQL server query to get list of all tables in database or get list of all the tables in SQL server 2008 database.

To get all the tables in SQL server 2008 database we need to write the query like as shown below

USE SampleDB
SELECT * FROM information_schema.tables


USE SampleDB

Once we run above query we will get output like as shown below


If you enjoyed this post, please support the blog below. It's FREE!

Get the latest,, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

subscribe by rss Subscribe by RSS subscribe by email Subscribe by Email


Anonymous said...


Anonymous said...

hi mujhe pure database se searching karani hai aur use aspx page par show karani hai .please give me any idea

Give your Valuable Comments

Note: Only a member of this blog may post a comment.

© 2015 All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.