DDL Support

[KKould]

Feature Request

Function

• CURRENT_TIMESTAMP

Create Table

• PRIMARY KEY (column_1, column_2, ...)
• UNIQUE (column_1, column_2, ...)
• Options
  • Default e.g. CREATE TABLE CUSTOMER (C_ID INTEGER DEFAULT '0' NOT NULL)

Ref: #103

Create Index

• CREATE UNIQUE INDEX u_index ON table(column_1, column_2, ...);
• Perf Unique Index Choose (options)

Alert Table

• ALTER TABLE table ADD column_1 INTERGER; ref: Alter table #104
• ALTER TABLE table MODIFY column_1 INTERGER;
• ALTER TABLE table CHANGE COLUMN column_1 column_2 INTERGER;
• ALTER TABLE table DROP COLUMN column_1; ref: feat: support drop column #109
• RENAME table TO table ;

Ref:

• support alert table #101

Desc

• Desc Table: support desc table #102