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 objectsALTER
to add constraints to a tableDROP
to drop an objectINSERT
to insert new dataUPDATE
to change existing dataDELETE
to delete the data
In a SQL Server database, you can also use programmatic objects. You can use triggers for advanced constraints or to maintain some redundant data such as aggregated data. You can use other programmatic objects for data abstraction, for an intermediate layer between the actual data and an application. The following programmatic objects are...