Documentation > USER GUIDE > SQL Manual > Data Definition

Data Definition

Schema Commands


CREATE SCHEMA	COMMENT ON SCHEMA	ALTER SCHEMA	DROP SCHEMA
SET SCHEMA

Data Definition


CREATE SEQUENCE	COMMENT ON SEQUENCE	ALTER SEQUENCE	DROP SEQUENCE

CREATE TABLE	COMMENT ON TABLE	COMMENT ON COLUMN	DROP TABLE
CREATE TABLE AS	ALTER TABLE ADD COLUMN	ALTER TABLE ALTER COLUMN	ALTER TABLE DROP COLUMN
CREATE TABLE FROM LOADER	ALTER TABLE ADD CONSTRAINT		ALTER TABLE DROP CONSTRAINT
	ALTER TABLE RENAME TO	ALTER TABLE RENAME COLUMN	ALTER TABLE SET SCHEMA
	ALTER TABLE SET INSERT ONLY	ALTER TABLE SET READ ONLY	ALTER TABLE SET READ WRITE

CREATE MERGE TABLE	ALTER TABLE ADD TABLE	ALTER TABLE SET TABLE	ALTER TABLE DROP TABLE
CREATE REMOTE TABLE	CREATE REPLICA TABLE	CREATE TEMPORARY TABLE

CREATE INDEX	CREATE IMPRINTS INDEX	CREATE ORDERED INDEX	DROP INDEX
COMMENT ON INDEX
CREATE TRIGGER	DROP TRIGGER

CREATE VIEW	DROP VIEW

CREATE FUNCTION	COMMENT ON FUNCTION	DROP FUNCTION	DROP ALL FUNCTION
CREATE FUNCTION EXTERNAL	CREATE FUNCTION LANGUAGE

CREATE PROCEDURE	COMMENT ON PROCEDURE	DROP PROCEDURE	DROP ALL PROCEDURE
CREATE PROCEDURE EXTERNAL

CREATE AGGREGRATE	COMMENT ON AGGREGRATE	DROP AGGREGRATE	DROP ALL AGGREGRATE
CREATE AGGREGRATE EXTERNAL

CREATE FILTER	COMMENT ON FILTER	DROP FILTER	DROP ALL FILTER

CREATE LOADER	COMMENT ON LOADER	DROP LOADER	DROP ALL LOADER

CREATE WINDOW EXTERNAL	COMMENT ON WINDOW	DROP WINDOW	DROP ALL WINDOW

CREATE TYPE EXTERNA	DROP TYPE
DECLARE