Data definition 

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, Data Definition