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. 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