SQL Server 2017 Developer???s Guide

DDL, DML, and programmable objects

As a developer, you are often also responsible for creating the database objects. Of course, in an application, you need also to insert, update, and delete the data. In order to maintain data integrity, meaning enforcing data to comply with business rules, you need to implement constraints. In our quick review of the data definition language (DDL) and data modification language (DML) elements, we will look at the following statements:

• CREATE for creating tables and programmatic objects
• ALTER to add constraints to a table
• DROP to drop an object
• INSERT to insert new data
• UPDATE to change existing data
• DELETE to delete the data

In a SQL Server database, you can also use programmatic objects. You can use triggers ...