Help Center/Data Warehouse Service/Tool Guide/DSC/MySQL Syntax Migrating/Table (Optional Parameters and Operations)
Updated on 2025-04-10 GMT+08:00
Table (Optional Parameters and Operations)
This section describes the migration syntax of tables (optional parameters and operations). The migration syntax determines how the keywords and features are migrated. GaussDB(DWS) does not support table migration. Currently, all table migration methods are temporary.
- ALGORITHM
- ALTER TABLE RENAME
- AUTO_INCREMENT
- AVG_ROW_LENGTH
- BLOCK_SIZE
- CHARSET
- CHECKSUM
- CLUSTERED KEY
- COLLATE
- COMMENT
- CONNECTION
- DEFAULT
- DELAY_KEY_WRITE
- DISTRIBUTE BY
- DIRECTORY
- ENGINE
- FOREIGN_KEY_CHECKS
- IF NOT EXISTS
- INDEX_ALL
- INSERT_METHOD
- KEY_BLOCK_SIZE
- LOCK
- MAX_ROWS
- MIN_ROWS
- PACK_KEYS
- PARTITION BY
- PASSWORD
- ROW_FORMAT
- STATS_AUTO_RECALC
- STATS_PERSISTENT
- STATS_SAMPLE_PAGES
- UNION
- WITH AS
- CHANGE (Column Modification)
- CHECK Constraint
- DROP (Table Deletion)
- LIKE (Table Cloning)
- MODIFY (Modifying a Column)
- TRUNCATE (Table Deletion)
- ROUNDROBIN Table
- RENAME (Table Renaming)
- SET|DROP COLUMN DEFAULT VALUE
- Renaming a Column
- Row-Store/Column-Store Table Compression
- Adding/Deleting a Column
Parent topic:MySQL Syntax Migrating
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
