MySQL support (alter/drop/rename table) #56
Description
- 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