![]() If the column that is dropped is a part of the distribution key (see ALTER TABLE (distribution/partitioning) for more information), then the distribution keys are dropped and the new rows of the table will be distributed randomly across the cluster nodes.When you specify this option, the foreign key reference to the column is deleted even when the referencing table does not belong to the current user. If a column that you need to delete has foreign key references, then specify the option CASCADE CONSTRAINTS.For information about constraints, refer to the ALTER TABLE (constraints) section. ![]() If the clause IF NOT EXISTS is specified, then statement does not throw an error message if the column already exists.For more information, refer to the Identity Columns section. For identity columns, a monotonically increasing number is generated if the table already possesses rows.For information on the permissible expressions for default value expr, refer to Default Values section. If the default value expression is not appropriate for the specified data type, an error message is displayed, and the statement is not executed.If the table already contains rows, the content of the inserted column will be set to the default value if it has been specified.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |