Shulou(Shulou.com)06/01 Report--

In this project, in order to synchronize the database, we use the trigger mechanism. When migrating the database, we need to obtain those tables in the database that use triggers to facilitate the production of database installation packages.

Idea:

The trigger is managed as an object in MSSQL, so we can query it through the sysobjects table.

So we wrote a trigger to get the SQL.

SELECTobject_name (a.parent_obj) as [Table], a.name as [trigger], (case when b.is_disabled=0 then'in use 'else' disable 'end) as [trigger status], b.create_date as [write date], b.modify_date as [Last modified date] C.text as [trigger content] FROM sysobjects aINNER JOIN sys.triggers bON b.object_id=a.idINNER JOIN syscomments cON c.id=a.idWHERE a.xtypetriggered trigger tr'-- tr stands for type trigger ORDER BY [table]

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.