SQL Server 16 - Foreign Key

[@WSJess]

I'm in a database class and your videos are helping me understand so much.

[@MrsCountryGirl23]

Thank you Caleb for making these videos! I am currently in school for Software Development and these videos are super helpful! Appreciate it!

[@Andy_Toys]

great sense of humor!😃😃😃🤣

[@blackclover5561]

Hey Caleb, I know this is 2years late, but I just found your channel and wanted to ask you a question regarding the UNIQUE attribute/constraint. Here you said that if you add UNIQUE to the column, the parent can only have ONE child. WHICH column are you talking about? Do we add UNIQUE to the parent or the child? To me it seems redundant to add UNIQUE to the parent as it is a PRIMARY KEY which you mentioned that it already includes UNIQUE constraint in itself, nevertheless I'd like to hear your answer on this. Cheers. Edit: I tried adding UNIQUE when I created the second table to the column that I meant to make a FK, I made that column FK, and when I tried adding another FK to the next column, it succeeded! Did I get something wrong or what you said about a Primary key having only one foreign key if UNIQUE was used wasn't true?

[@lordamateur]

I think you meant to say "So you would obviously make the COMMENTS column not null" instead of the "Poster" column at the end.

[@han_anonymous]

Sql (the language) attributes vs Entity attributes

[@RoyMundson]

awesome stuff

[@besky676]

Thank you all the way from the UK!

[@pratyushsingh6128]

when will u start oracle db again man i want it bad?????

[@codebreakthrough]

Jan. 1st :)

[@FacePalmProduxtnsFPP]

unlock databases from foreign countries you say?? I'll do! ;) XD

[@el7517]

Love u

[@zealpacsolution8256]

Its ok to have an orphaned child LOL

[@prisonmike7924]

Lmao 😂🤣

[@niks670]

i realy hate this subject......actully i m in class 11 and i choose this subject as option but i dont know that time that this subject is so boring. Always my %age get down bcoz of only this subject i really heated this subject but now after watching ur vedio i try to learn this with more interest...:)thnqq caleb sir for bring my interest in this sir i want that u also tell about some SQLqureies in this....thnqq sir