To display the source text of a trigger, execute sp_helptext:
sp_helptext deltitle
# Lines of Text --------------- 1 text --------------------------------------------- create trigger deltitle on titles for delete as if (select count(*) from deleted, salesdetail where salesdetail.title_id = deleted.title_id) >0 begin rollback transaction print "You can’t delete a title with sales." end
If the source text of a trigger was encrypted using sp_hidetext, Adaptive Server displays a message advising you that the text is hidden. See the Reference Manual: Procedures.
If the system security officer has reset the allow select on syscomments.text column parameter with sp_configure (as required to run Adaptive Server in the evaluated configuration), you must be the creator of the trigger or a system administrator to view the source text of a trigger through sp_helptext. (See Chapter 12, “Introduction to Security,” in the System Administration Guide: Volume 1.
