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...