Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 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
Introduction:

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.
Description:

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

                  OR   

USE SampleDB
SELECT * FROM SYS.tables

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

Demo



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

Get the latest Asp.net, C#.net, 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

2 comments :

Anonymous said...

fine

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 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.