DDL - Data Definition Language

As the definition described above, DDL is a set of SQL commands that are used to make (create), modify (alter) and delete (drop) the structure and data type definitions of database objects.

Objects in the database in question - in MySQL - is as follows:

     Database
     Table
     View
     Index
     Procedure (Stored Procedure)
     function
     Trigger
List of DDL commands in MySQL 5.0
Here are examples of DDL commands used in MySQL. Click on the link to see details of the use of the command.

     Preparation of (CREATE)
         CREATE DATABASE
         CREATE FUNCTION
         CREATE INDEX
         CREATE PROCEDURE
         CREATE TABLE
         CREATE TRIGGER
         CREATE VIEW

     Changes (ALTER and RENAME)
         ALTER DATABASE
         ALTER FUNCTION
         ALTER PROCEDURE
         ALTER TABLE
         ALTER VIEW
         RENAME TABLE

     Deletion (DROP)
         DROP DATABASE
         DROP FUNCTION
         DROP INDEX
         DROP PROCEDURE
         DROP TABLE
         DROP TRIGGER
         DROP VIEW