How to setup a Foreign Key Constraint on a SQL Server 2019 database.

Publicado em: 13 Janeiro 2022
no canal de: Software Nuggets

579

How to Create a Foreign Key on your tables.

This video will show how to create foreign key relationships between the parent and child tables.

I will show by example, how each of the constraint restrictions works, when the Update and Delete statements are executed: CASCADE, SET NULL, NO ACTION and SET DEFAULT.

So, a foreign key, sometimes abbreviated with FK, is a column or a combinations of several columns that enforce a constraint between two tables. This constraint promotes better data.

Parent table must have either a primary key on the needed column, or a unique index on that column.

Constraint on a SQL database

Referential integrity, foreign key, foreign keys, constraint, fk constraints, fk constraints explained, fk constraint errors,

#softwareNuggets, #ForeignKeys, #SQLServer

Nesta página do site você pode assistir ao vídeo on-line How to setup a Foreign Key Constraint on a SQL Server 2019 database. duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Software Nuggets 13 Janeiro 2022, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 579 vezes e gostou 7 espectadores. Boa visualização!

284