docs
docs copied to clipboard
Published
20 hours ago •
cockroachdb
cockroachdb
sql/schemachanger: implement ALTER TABLE ... ADD PRIMARY KEY
Exalate commented:
Related PR: https://github.com/cockroachdb/cockroach/pull/86195 Commit: https://github.com/cockroachdb/cockroach/commit/f9ac069d688826f41c83d89768551cd5ffb60c14
Release note (sql change): When running ALTER TABLE ... ADD PRIMARY KEY
or ALTER TABLE ... ADD CONSTRAINT ... PRIMARY KEY in a single-statement,
implicit transaction, when no primary key had been added to the table, the
old rowid column which had been automatically created as the table's
PRIMARY KEY will now be dropped.
Jira Issue: DOC-5381
