Data Definition Statements

• CREATE TABLE
  • Table Definition
  • Column Definition
  • Constraint Definition
  • Column Option
  • Table Option
  • CREATE TABLE LIKE
  • CREATE TABLE AS SELECT
• ALTER TABLE
  • ADD COLUMN Clause
  • ADD CONSTRAINT Clause
  • ADD INDEX Clause
  • ALTER COLUMN ... SET DEFAULT Clause
  • AUTO_INCREMENT Clause
  • CHANGE/MODIFY Clauses
  • Column's COMMENT
  • RENAME COLUMN Clause
  • DROP COLUMN Clause
  • DROP CONSTRAINT Clause
  • DROP INDEX Clause
  • DROP PRIMARY KEY Clause
  • DROP FOREIGN KEY Clause
• DROP TABLE
• RENAME TABLE
• CREATE INDEX
  • COMMENT of Index
• ALTER INDEX
• DROP INDEX
• CREATE VIEW
  • Condition for Creating Updatable VIEW
  • View's COMMENT
• ALTER VIEW
  • ADD QUERY Clause
  • AS SELECT Clause
  • CHANGE QUERY Clause
  • DROP QUERY Clause
  • COMMENT Clause
• DROP VIEW
• RENAME VIEW
• CREATE SERIAL
  • COMMENT of Serial
• ALTER SERIAL
• DROP SERIAL
• Accessing Serial
  • Pseudocolumns
  • Functions