Modify the names, columns and constraints of an existing table.
|ADD / DROP COLUMN||Adds or drops a column. When adding a column, all existing rows will have NULL value for the new column.|
|ADD / DROP PRIMARY KEY||Adds or drops a primary key column. A table can have one primary key column. Primary keys must contain unique values and cannot contain NULL values.|
To drop partitions, specify one or more column values for the partition key, or a range of values by using the BETWEEN clause.
The partitions where the value exists, or that are within the given range, will be dropped.
|RENAME||Lets you change the table name or move the table to a different schema.|
|RENAME COLUMN||Lets you change a column's name. Applicable only to non-external tables. Please note that views must be updated manually to use the new column name instead of the old one. Join indexes and Cubes would still work as before, but the SHOW CUBES command may still present the old column name. (Supported from Jethro v3.4.4 and up)|