SELECT A.text
  FROM syscomments A
 WHERE A.id = Object_Id(:sTrigger)
 ORDER BY colid

SELECT SUBSTR(text,1,Length(text) - 1), line
  FROM all_source
 WHERE type = 'TRIGGER'
   AND owner = :sOwner
   AND name = :sTrigger

SELECT A.text
  FROM syscomments A, sysobjects B
 WHERE A.id = B.id
   AND B.id = Object_Id(:sTrigger)
 ORDER BY colid

IF (SELECT count(*)
      FROM sys.syscolumn c
      JOIN sys.sysdomain d ON c.domain_id=d.domain_id
      JOIN sys.systable t ON c.table_id=t.table_id
     WHERE t.table_id = (SELECT A.table_id
                           FROM sys.SYSTABLE A, dbo.sysusers B
                          WHERE Upper(A.table_name) =
                                Upper('SYSTRIGGER')
                            AND A.creator = B.suid)
                            AND Upper(c.column_name) =
                                Upper('object_id')) > 0
BEGIN
    SELECT IsNull(source, trigger_defn) as 'text'
      FROM SYSTRIGGER
     WHERE object_id = Object_Id(:sTrigger)
END
ELSE
BEGIN
    SELECT IsNull(source, trigger_defn) as 'text'
      FROM SYSTRIGGER
     WHERE Cast(trigger_id+300000 as integer) = Object_Id(:sTrigger)
END

QweryBuilder Trial 19,672 KB - Version: 7.1.1

QweryBuilder is an SQL Editor and Query Tool. Its purpose is to make accessing information from a database simple, quick, accurate and efficient. Work with your SQL Server, ASE, SQL Anywhere and Oracle databases in one single application.