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 - Get List of All Table Names in Database

Jun 12, 2013

Here I will explain simple SQL Query to get all table, procedure names in database or How to get list of all tables names in SQL Server Database or How to Get list of all procedures in SQL Server database.  


In previous articles I explained Create database schema diagrams in SQL Server, Delete Duplicate records from SQL Server, Exception handling in SQL Server stored procedure, Reading xml file using SQL Server and many articles relating to SQL Server. Now I will explain how to get all tables and stored procedures in database using SQL Server.

Get List of table names in database

To get list of tables in SQL Server we need to write the query like as shown below

USE SampleDB

Get List of Stored Procedures in database

To get list of procedures in SQL Server we need to write the query like as shown below

USE SampleDB


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

This is abhinavsingh993 ,simply great and innovative now please sir would you guide me to know how to do CRUD operations using .xsd(dataset) files.

Unknown said...

sir i need help of installing sql and working on sql please help me i am doing MCA final year

Unknown said...

iHi Sir, in my sql i want to know this meaning if(a=-1,0=0,a=b) please can u answer ...

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.