Data definition overview

<< Click to Display Table of Contents >>

Navigation:  Local SQL > Data Definition Language >

Data definition overview

 Previous pageReturn to chapter overviewNext page

 

Local SQL supports data definition language (DDL) for creating, altering, and deleting tables and indexes.

Local SQL does not permit the metadata object names to be represented by parameters in DDL statements.

Local SQL supports the following DDL statements:

DDL Statement
Description

CREATE TABLE
Creates a new table.

ALTER TABLE
Adds columns to and deletes columns from an existing table.

DROP TABLE
Deletes an existing table.

CREATE INDEX
Creates a new secondary index for an existing table.

DROP INDEX
Deletes an existing primary or secondary index.