Create Relationships In Sql Server Management Studio In Sql Server 2008


show more Creating relationships in SQL Server Management Studio provides you with in-depth training on Business. Taught by Simon Allardice as part of the SQL Server 2008 Essential Training show less
please wait ...

Creating relationships in SQL Server Management Studio

I am going to go ahead and describe a one-to- many relationship between two of my own tables. So I have two very-very simple tables here. I have a product table, which has a few products in it right now. It's got a ProductID as the unique key, the primary key for this. That's automatically incrementing, ranging from roughly 1000 through 1013 right now, and I also have an OrderItem table. This itself has its own primary key, OrderItemID, that I don't really care about, but it's got a place for a ProductID and this is going to become the foreign key.

I'd like to be able to create multiple order items for each product so that ProductID 1001 can be used several times if I deem it necessary. That means our many-to-one relationship is one product, many order items. So how do I make it? Well I am going to close down these tables. There are a couple of different ways I can do this. One way would be to go to the Database Diagrams area, add a new satabase diagram, grab the two tab...

Creating relationships in SQL Server Management Studio
Video duration: 8m 14s 6h 54m Beginner

Viewers:

Creating relationships in SQL Server Management Studio provides you with in-depth training on Business. Taught by Simon Allardice as part of the SQL Server 2008 Essential Training

Subjects:
Business Developer IT
Software:
SQL Server
Author:
please wait ...