DEV Community

Clever Cottonmouth
Clever Cottonmouth

Posted on

SP_HELPTEXT

sp_helptext is used to display the complete text of a stored procedure, view, or trigger that is stored in a database. When executed, it retrieves and shows the definition (the actual code) of the stored procedure or other objects, allowing you to view the SQL code that was used to create it. This is useful for inspecting or modifying the code of an existing stored procedure.

SP_HELPTEXT 'sp_name'

Top comments (0)