From the course: Learning Relational Databases

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Establish relationships in SQL Server

Establish relationships in SQL Server

From the course: Learning Relational Databases

Start my 1-month free trial

Establish relationships in SQL Server

“

- [Instructor] The next part to creating the database in SQL Server is to hook our tables together with relationships. In order to do that here in SQL Server we need to find each of the tables we were interested in inside of the tables folder for our database and we're going to find the child table in the relationship. In this case the first relationship I want to work on is between customers and invoices and in this relationship the invoices table servers as the child table. Let's go ahead and right click on it and we'll go up to design. That will bring us back into the design window that we were working with a moment ago. Then I need to find the relationships button and normally it's on the toolbar, but on my screen it's currently off the screen because of the resolution. In order to find it I'll press the downward pointing button here on the far right hand side of the toolbar and then we'll find the relationships button here. It's the icon with the two tables linked with a plus…

Contents