Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  T-SQL Foreign Keys

Author  Topic  gds Starting Member 29 Posts Posted - 2001-03-23 : 01:13:46 SCENARIO: CREATE TABLE XH ( id char(7) primary key not null, name char(50) ); CREATE TABLE XD ( id char(7), phone char(100) ); XH is the header table and XD is detailed table. I want to create a link the header and detail table, by creating a foreign key in XD table. Can someone give me the T-SQL statement?