devxlogo

Display the Contents of a Stored Procedure

Display the Contents of a Stored Procedure

A trigger is a stored procedure that runs automatically when various events happen (update, insert, delete, etc.) To display the contents of a Trigger, use a query similar to the following:

exec sp_helptext @objname = 'StoredProcedureName'

devx-admin

Share the Post: