From the course: Database Foundations: Data Structures
Join today to access over 25,300 courses taught by industry experts.
Create a relationship between tables
From the course: Database Foundations: Data Structures
Create a relationship between tables
- [Instructor] Adding the foreign key column to a table is the first step in creating a relationship. Now, we need to tell the RDBMS about the link between our orders and customers tables so that it can enforce the connection between rows. Make sure that you have the two trees database selected in the SQL server instance, and then come up to file and open file. In the chapter four folder, find the relationship dot SQL file and open it up. Now, before we go on, you might have a number of red underlines that are appearing throughout this script. As your data studio keeps track of the object names that you've used in your databases so that it can help you write commands, but it sometimes needs to be manually updated. Right click anywhere here on the main portion of the screen and choose command pallet from the pop-up menu. Then do a search for refresh IntelliSense cache. When you find it, go ahead and give that a click and as…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.