Script of DDL triggers

How do I view the script of the DDL triggers? The answer is not sp_helptext 'DDL trigger' Because DDL triggers are defined at database / server level and not at any table level So they are not stored in a system objects like sys.objects and the usage of sp_helptext , object_name , etc wont work Using this select * from sys.objects where type = 'tr' You can see all triggers except DDL triggers To know the DDL trigger , you need to use one of the following select * from sys.triggers...(read more)

Source Click Here.