Foreign Keys in SQL Server: What They Are and How to Use Them

This video is part of LearnItFirst's Transact-SQL Programming: SQL Server 2008/R2 course. More information on this video and course is available here:

http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx?an=YouTube

This is the first video in a two-video set on foreign keys. The foreign key is probably the most confusing of the constraint types, but the examples in these videos will help clarify what it's used for and how to use it. To demonstrate foreign keys, Scott uses a scenario in which users can recover a lost password with a password hint and answer.

Highlights from this video:

* What is the purpose of foreign keys?
* Differences between primary keys and unique constraints
* Parent/child relationships
* Defining a "one to many" relationship

and much more

Category:

Science & Technology

Tags:

• sql server 2008
• r2
• foreign key
• primary
• unique
• constraint
• t sql
• training
• instruction
• lesson

[myburneddesire]

@HeathDutton Kevin Flynn ?



[Ahmedkillerdemon]

i want to add field and the table has forign key do I include the forign key in sql statement or not ?

and if yes how do u write it?

[HeathDutton]

Sounds like being taught by the guy from Tron!