sp_helptext

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.