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 - Get List of All Stored Procedures from Database in SQL Server

Jun 13, 2013
Introduction

Here I will explain simple SQL Query to get list of all stored procedures from SQL Server database or How to get list of all stored procedures in SQL Server Database or How to Get list of all tables in SQL Server database. 

Description:


Get List of Stored procedure names in database

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


USE SampleDB

SELECT * FROM SYS.PROCEDURES
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

SELECT * FROM SYS.TABLES


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

5 comments :

Irtekaz Ahmed Khan said...

properties of table

Selva said...

hi ahmad , below query will show you properties of table,maybe its correct or not just chech it out..

"exec sp_columns Table Name"

Unknown said...

Hi Sir....
what is meant by the following if condition in mysql workbench storedprocedure?what output it will return?
(here, para_disability_id is the parameter am passing and candidates.disability_id is the value i taken from table)

if(para_disability_id=-1,0=0,cand.disability_id=para_disability_id)

Anonymous said...

USE SampleDB
SELECT * FROM SYS.PROCEDURES

gives incorrect result. i have 10 database in SQL Sever. It is not giving correct result.

Unknown said...

it's working.........

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.