SQL includes a sub-language for defining schemas, the data definition language (DDL), along with a sub-language for modifying data, the data manipulation language (DML).

The move from Microsoft SQL Server 2000 to 2005 was a big leap with many new functionalities and features introduced. The concept of DDL Triggers was one such new feature.