6/11/2023 0 Comments Tableplus check constraintFor more information about logical records, see Group Changes to Related Rows with Logical Records. If a column is nullable, and there is no explicit default value set, NULL becomes the implicit default value of the column.ĭo not specify CASCADE if the table will be included in a merge publication that uses logical records. For this constraint to execute, all foreign key columns must have default definitions. For this constraint to execute, the foreign key columns must be nullable.Īll the values that make up the foreign key are set to their default values when the corresponding row in the parent table is updated. The Database Engine raises an error, and the update action on the row in the parent table is rolled back.Ĭorresponding rows are updated in the referencing table when that row is updated in the parent table.Īll the values that make up the foreign key are set to NULL when the corresponding row in the parent table is updated. Specifies what action happens to rows in the table altered when those rows have a referential relationship and the referenced row is updated in the parent table. Specifies the properties of a PRIMARY KEY, UNIQUE, FOREIGN KEY, a CHECK constraint, or a DEFAULT definition added to a table by using ALTER TABLE.
0 Comments
Leave a Reply. |