Entering content frame

Data definition Locate the document in the library structure

The following sections contain an introduction to the data definition language (DDL) used by the database system.

SQL statements for data definition

CREATE TABLE statement

DROP TABLE statement

ALTER TABLE Statement

RENAME TABLE statement

RENAME COLUMN Statement

EXISTS TABLE statement

CREATE SCHEMA Statement

RENAME SCHEMA statement

DROP SCHEMA statement

CREATE DOMAIN statement

DROP DOMAIN Statement

 

CREATE SEQUENCE Statement

DROP SEQUENCE statement

 

CREATE SYNONYM statement

DROP SYNONYM Statement

RENAME SYNONYM Statement

CREATE VIEW statement

DROP VIEW statement

RENAME VIEW statement

CREATE INDEX statement

DROP INDEX statement

ALTER INDEX statement

RENAME INDEX statement

CREATE DBPROC[EDURE] Statement

DROP DBPROC[EDURE] Statement

 

CREATE SYSTEM TRIGGER Statement

DROP SYSTEM TRIGGER Statement

 

CREATE FUNCTION statement

DROP FUNCTION Statement

 

CREATE TRIGGER statement

DROP TRIGGER statement

 

COMMENT ON statement

 

 

Examples

SQL Tutorial, Structure linkData Definition

 

Leaving content frame