The schema statements, the part of the SQL language commonly known as DDL, Data Definition Language, are used to create, alter and drop schema (database) objects.

 

 


 

CREATE TABLE statement

CREATE INDEX statement

CREATE VIEW statement

CREATE TRIGGER

CREATE PROCEDURE statement

CREATE FUNCTION statement

CREATE ASSEMBLY statement

 

ALTER TABLE statement

 

DROP TABLE statement

DROP INDEX statement

DROP VIEW statement

DROP TRIGGER statement

DROP ROUTINE statement

DROP ASSEMBLY statement