Data Definition Language Statements

Use the Data Definition Language (DDL) elements of SQL to create, delete, and change the underlying structure of a database. DDL does not enable you to change or retrieve information stored in the database, but deleting parts of the database structure destroys any data contained in the deleted portions.

The following statements make up the DDL portion of ADOCE SQL:

• Table Operations
  • CREATE TABLE
  • DROP TABLE
• Index Operations
  • CREATE INDEX
  • DROP INDEX
• Universal Operations
  • ALTER TABLE