August 9, 2008 at 10:11 pm
Hi to all,
I have a small doubt.
If we want to know the see all the tables in a database we normally use sp_tables.I want to see all the stored procedures ina database. how we can see all the stored procedures in a database.
Thanks,
sandhya
August 9, 2008 at 10:59 pm
Select * from sys,procedures
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 10, 2008 at 5:00 pm
I'd recommend select * from information_schema.routines
August 10, 2008 at 6:35 pm
Either of the other suggestions will work, but I would agree with Steve because INFORMATION_SCHEMA is an ANSI standard while sys.procedures is a Microsoft view that could be deprecated or changed.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 10, 2008 at 6:56 pm
Steve Jones - Editor (8/10/2008)
I'd recommend select * from information_schema.routines
Oh yeah, I forgot about this one. I like it much better.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 17, 2013 at 6:22 am
You can use below query:
sp_stored_procedures. Just try it once.
Thanks,
Arif.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply