MySQL support (alter/drop/rename table)

[nene]

• ALTER TABLE
  • ADD [COLUMN] name definition
    • FIRST | AFTER col_name
    • ADD COLUMN (...)
  • ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
  • ADD {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
  • ADD CONSTRAINT
  • DROP {CONSTRAINT | CHECK}
  • ALTER {CONSTRAINT | CHECK}
  • ALGORITHM [=] {DEFAULT | INSTANT | INPLACE | COPY}
  • ALTER COLUMN
    • SET {VISIBLE | INVISIBLE}
    • SET DEFAULT
    • DROP DEFAULT
  • ALTER INDEX index_name {VISIBLE | INVISIBLE}
  • CHANGE COLUMN old_col_name new_col_name column_definition [FIRST | AFTER col_name]
  • [DEFAULT] CHARACTER SET [=] charset_name [COLLATE [=] collation_name]
  • CONVERT TO CHARACTER SET charset_name [COLLATE collation_name]
  • {DISABLE | ENABLE} KEYS
  • {DISCARD | IMPORT} TABLESPACE
  • DROP [COLUMN]
  • DROP {INDEX | KEY}
  • DROP PRIMARY KEY
  • DROP FOREIGN KEY name
  • FORCE
  • LOCK [=] {DEFAULT | NONE | SHARED | EXCLUSIVE}
  • MODIFY [COLUMN] name definition [FIRST | AFTER col_name]
  • ORDER BY col_name, ...
  • RENAME COLUMN old TO new
  • RENAME {INDEX | KEY} old TO new
  • RENAME [TO | AS]
  • {WITHOUT | WITH} VALIDATION
  • partition options:
    • ADD PARTITION (partition_definition)
    • DROP PARTITION partition_names
    • DISCARD PARTITION {partition_names | ALL} TABLESPACE
    • IMPORT PARTITION {partition_names | ALL} TABLESPACE
    • TRUNCATE PARTITION {partition_names | ALL}
    • COALESCE PARTITION number
    • REORGANIZE PARTITION partition_names INTO (partition_definitions)
    • EXCHANGE PARTITION partition_name WITH TABLE tbl_name [{WITH | WITHOUT} VALIDATION]
    • ANALYZE PARTITION {partition_names | ALL}
    • CHECK PARTITION {partition_names | ALL}
    • OPTIMIZE PARTITION {partition_names | ALL}
    • REBUILD PARTITION {partition_names | ALL}
    • REPAIR PARTITION {partition_names | ALL}
    • REMOVE PARTITIONING
• DROP TABLE
  • TEMPORARY
  • IF EXISTS
  • CASCADE | RESTRICT
  • multiple tables
• RENAME TABLE