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

Publicado el: 13 enero 2022
en el 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

En esta página del sitio puede ver el video en línea How to setup a Foreign Key Constraint on a SQL Server 2019 database. de Duración hora minuto segunda en buena calidad , que subió el usuario Software Nuggets 13 enero 2022, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 579 veces y le gustó 7 a los espectadores. Disfruta viendo!

284