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, SAP ASE 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 SAP ASE 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, Introduction to Security, in the Security Administration Guide.