![]() ALTER COLUMN column_name TYPEĪ clause that changes the size of a column defined as a VARCHAR data type. Table name beginning with '#' indicates a temporary table. You can't rename a permanent table to a name that begins with '#'. The maximum table name length is 127 bytes OWNER TO new_ownerĪ clause that changes the owner of the table (or view) to theĪ clause that renames a table (or view) to the value specified in CASCADE is an option for DROP CONSTRAINT. CASCADEĪ clause that removes the specified constraint and anything dependent on RESTRICT is an optionįor DROP CONSTRAINT. To reduce the time to run the ALTER TABLE command, you can combine some clauses ofĪmazon Redshift supports the following combinations of the ALTER TABLE clauses:įrom information_schema.table_constraints RESTRICTĪ clause that removes only the specified constraint. | DROP PARTITION ( partition_column= partition_value ) | ALTER DISTSTYLE KEY DISTKEY column_name | ALTER COLUMN column_name ENCODE encode_type. | ALTER COLUMN column_name ENCODE encode_type, | ALTER COLUMN column_name ENCODE new_encode_type | ALTER COLUMN column_name TYPE updated_varchar_data_type_size Table owner with the USAGE privilege on the schema
0 Comments
Leave a Reply. |