devxlogo

Get All the Stored Procedure Names In One Shot

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 spnameFROM         sysobjectsWHERE     (xtype = 'p') AND (name NOT LIKE 'dt%')ORDER BY name

devx-admin

Share the Post: