Like SET DEFAULT, these forms only affect the behavior of subsequent INSERT and UPDATE commands they do not cause rows already in the table to change. These forms change whether a column is an identity column or change the generation attribute of an existing identity column.
RENAME CONSTRAINT constraint_name TO new_constraint_nameĪLTER TABLE ALL IN TABLESPACE name ]ĪTTACH PARTITION partition_name AS IDENTITY