AWS aurora-dsql documentation change
Summary
Added documentation for identity column actions in ALTER TABLE syntax, including SET GENERATED, SET sequence_option, RESTART, and DROP IDENTITY commands
Security assessment
The changes describe syntax extensions for managing identity columns without any security context. No vulnerabilities, exploits, or security controls are mentioned.
Diff
diff --git a/aurora-dsql/latest/userguide/alter-table-syntax-support.md b/aurora-dsql/latest/userguide/alter-table-syntax-support.md index 7bd6ba643..4eb2f0b4d 100644 --- a//aurora-dsql/latest/userguide/alter-table-syntax-support.md +++ b//aurora-dsql/latest/userguide/alter-table-syntax-support.md @@ -4,0 +5,2 @@ +Identity column actions + @@ -23,0 +26,2 @@ + ALTER [ COLUMN ] column_name { SET GENERATED { ALWAYS | BY DEFAULT } | SET sequence_option | RESTART [ [ WITH ] restart ] } [...] + ALTER [ COLUMN ] column_name DROP IDENTITY [ IF EXISTS ] @@ -25,0 +30,14 @@ +## Identity column actions + +**`SET GENERATED{ ALWAYS | BY DEFAULT }` / `SET `sequence_option`` / `RESTART`** + + +These forms change whether a column is an identity column or change the generation attribute of an existing identity column. See [CREATE TABLE](./create-table-syntax-support.html) for details. 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. + +The `sequence_option` is an option supported by [ALTER SEQUENCE](./alter-sequence-syntax-support.html) such as `INCREMENT BY`. These forms alter the sequence that underlies an existing identity column. + +**`DROP IDENTITY [ IF EXISTS ]`** + + +This form removes the identity property from a column. If `DROP IDENTITY IF EXISTS` is specified and the column is not an identity column, no error is thrown. In this case a notice is issued instead. + @@ -34 +52 @@ CREATE TABLE -CREATE VIEW +CREATE SEQUENCE