如何在两个表之间创建外键 [英] how to create foreign key between two tables

问题描述

请告诉我们如何在两个表之间创建外键...

pls some one tell that how to create foreign key between two tables...

推荐答案

看看这些:
视频:07-如何在两个表之间添加关系(外键)... [ ^ ]
MSDN:创建外键关系 [ MSDN:如何:创建表之间的关系 [ Microsoft SQL Server中的外键 [ ^ ]

试试！

Have a look at these:
Video: 07-How to add a relationship (Foreign Key) between two tables ...[^]
MSDN: Create Foreign Key Relationships[^]
MSDN: How to: Create Relationships Between Tables[^]
Foreign Keys in Microsoft SQL Server[^]

Try!

检查此网站

Check this website

http://blog.sqlauthority.com/2008/09/08/sql-server-%E2%80%93-2008-creating-primary-key-foreign-key-and-default-constraint/[^]

创建table1
创建table2
更改表并将foriegn键添加到您喜欢的任何表中

如何创建和更改外键，请阅读以下内容
http://msdn.microsoft.com/en-us/library/ms177463 (v = sql.90).aspx [

Create table1
create table2
alter table and add foriegn keys to any of the table you like

how to create and alter foreign keys, read following
http://msdn.microsoft.com/en-us/library/ms177463(v=sql.90).aspx[^]

这篇关于如何在两个表之间创建外键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！