This commit extends cockroachdb#86071 to support `ALTER TABLE ... ADD PRIMARY KEY` in implicit transactions in the case that the existing primary key uses the default `rowid` primary key. It adopts ...

To create a SQL DB2 table with primary and foreign keys, use the CREATE TABLE statement with the CONSTRAINT clause for primary keys and the REFERENCES clause for foreign keys.

Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform certain actions when a primary key field in a primary key-foreign key relationship is ...