Quadcap Embeddable Database

• QED Home
• User's Guide
• Developer's Guide
• API Documentation
• SQL Reference
• FAQ
• Changes

Quadcap Software

• Home
• Download
• Products
• Services
• Purchase
• Support
• About

alterTableStmt
  :  "alter" "table" sqlId 
    (  addConstraint 
    |  addColumn 
    |  dropConstraint 
    |  dropColumn 
    |  alterColumn 
    |  renameTable 
    ) 
  ;

Various operations are specified by SQL92 to modify an existing table definition:

• ALTER TABLE ADD COLUMN
• ALTER TABLE ADD CONSTRAINT
• ALTER TABLE ALTER COLUMN
• ALTER TABLE DROP COLUMN
• ALTER TABLE DROP CONSTRAINT