DEV Community

Clever Cottonmouth
Clever Cottonmouth

Posted on

1

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)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more