SQL
SERVER – Stored Procedure to display code (text) of Stored Procedure, Trigger,
View.
System stored procedure that prints the text of
a rule, a default, or an unencrypted stored procedure, user-defined function,
trigger, or view.
sp_helptext can be passed any SQL Server object
that contains code, for example stored procedures, views, functions, triggers
etc. It then returns the code for that object.
Syntax
:
sp_helptext @objname sp_helptext Stored Procedure or functions or Views or triggers
No comments:
Post a Comment