Chapter 3. Data Definition Language and Security
This chapter covers methods available to the database designer and database user to create and modify database objects. It starts with the Data Definition Language (DDL) statements CREATE, ALTER and DROP.
The SQL language has two main divisions:
DDL— Data Definition Language, which is used to define and manage all the objects in an SQL database (discussed starting page 240), and
DML— Data Manipulation Language, which is used to select, insert, update and delete data in the tables contained in an SQL database (discussed starting page 423).
Microsoft SQL Server Books Online describes DDL nicely:
The Transact-SQL DDL used to manage objects such as databases, tables, and views is based on SQL-92 ...
Get Transact-SQL Desk Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
