How do you refer a field which is a part of a composite primary key

[database1]

The sequence follows like this:<br>1. create table integer(a int,b int,primary key(a,b))<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;--&gt;&nbsp;&nbsp;a table is created with both fields as composite primary<br>2. create table referinteger(a int references integer(a))<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;--&gt; the aim was to create a table with one of the field refering to a field in another table which is composite primary.<br>But it throws error,<br>please find a solution.<br><br>

 

[gummadi]

Hi,<br><br>It is not possible to reference a part of composite primary key.because a foreign key can created only if referenced column is unique or a primary key.<br>so if you want to reference a part of composite key ,you should have unique constraint on it or you have to reference whole part of composite primary key.<br><br>bye <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Gummadi

 

[foxdev]

2. create table referinteger(a int references integer(a<b><font color=red>, b</font></b>)) <p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br>

 

[gummadi]

Hi,<br>I tried to apply<br>2)create table referinteger(a int references integer(a, b))<br>after creating <br>1)create table integer(a int,b int,primary key(a,b)) <br>i am getting an below error<br><br>Server: Msg 8140, Level 16, State 1, Line 1<br>More than one key specified in column level FOREIGN KEY constraint, table 'referinteger'.<br><br>Gummadi