CODEWITHSUNDEEP
sql-serverms-access
namko
namko

Reputation: 647

Enforce referential integrity in MS Access vs Foreign Key Constrains in Microsost SQL Server Management Studio?

Is Enforce referential integrity the same thing as Foreign Key Constrains in MSSMS?

Upvotes: 1

Views: 109

Answers (1)

PhilS
PhilS

Reputation: 624

MS Access enforce referential integrity and SQL server forign key constraints are the same concept although SQL Server supports a more fleixible version of it.

SQL Server referential integrity supports multiple options when the parent record is altered: No Action, Cascade - on Delete and\or Update, set Null, set Default. For more info see https://learn.microsoft.com/en-us/sql/relational-databases/tables/primary-and-foreign-key-constraints?view=sql-server-2017#FKeys

MS Access enforce referential integrity only supports the 'No Action' and 'Cascade' options. See https://support.office.com/en-us/article/guide-to-table-relationships-30446197-4fbe-457b-b992-2f6fb812b58f#bm9

Upvotes: 2

Related Questions