Research on SQL Server trigger to implement referential integrity

Database integrity is an important research content of database security, triggers can enforce the more complex referential integrity, and this paper studies the approach of using DML triggers to implement SQL Server referential integrity. First, studies the working principle of DML triggers; Second, researches and creates DML triggers, focusing on explained the Transact-SQL creating parameters based on the illustration of DML triggers created; Finally, shows the achieve methods through many-many relationship examples, designs the database logical structure and physical structure, and achieves deleting trigger and modifies trigger. This content provides a concrete method to use the SQL Server database software development implement referential integrity, and it has broad application prospects.