You can use the
ALTER TABLE command to make schema changes to a table, and can be used in conjunction with several sub-commands.
Making changes to a schema makes an exclusive lock on tables. While these operations do not typically take much time, other statements may have to wait until the schema changes are completed.
The following table shows the sub-commands that can be used with the
ALTER TABLE command:
Adds a new column to a table.
Drops a column from a table.
Renames a column.
Renames a table.
Modifies (adds or reorders) the clustering keys in a table.
Drops all clustering keys.