DDL AND DML TERMINOLOGY

Database administrators sometimes throw around terminology that is
foreign to the average database user. The terms DDL and DML are two 
examples.

DDL and DML are subsets of the SQL language. DDL refers to the "data
definition language" portion of SQL. This subset of commands is used to
manage the objects in a database.

For each class of object, there are usually three statements. These are
typical examples of DDL statements.

CREATE TABLE
ALTER TABLE
DROP TABLE

CREATE PROCEDURE
ALTER PROCEDURE
DROP PROCEDURE

DML refers to the "data manipulation language" portion of SQL. This
subset manipulates the data contained within the tables and variables. 
By
using the DML portion of SQL, you can SELECT, INSERT, UPDATE, or DELETE
data.


----------------------------------------