TODAY'S HEADLINES | ARTICLE ARCHIVE | FORUMS | TIP BANK

Specialized Dev Zones

eBook Library

.NET

Java

C++

Web Dev

Architecture

Database

Security

Open Source

Enterprise

Mobile

Special Reports

10-Minute Solutions

DevXtra Editors' Blog

Home » Tip Bank » Database Development » SQL

Language: SQL
Expertise: Beginner

Jan 31, 2005

Get All the Stored Procedure Names In One Shot

The following query will list all the stored procedure names available in the current database:


SELECT     name AS spname
FROM         sysobjects
WHERE     (xtype = 'p') AND (name NOT LIKE 'dt%')
ORDER BY name

Jaya Nehru Kumar

Submit a Tip

Browse "Database Development" Tips

Browse All Tips

Comment and Contribute