Primary key to foreign key.

eevanich · #1 09-16-2008, 05:21 PM

If i have set up a primary key in one table and i want it to be the foreign key in another table in my database, how do i like it to the second table?

slapshotw · #2 09-16-2008, 05:30 PM

You can use alter table. Something to the effect of:

Code:

alter table *tableName* add Foreign Key (column) references othertable(otherColumn)

.

eevanich · #3 09-17-2008, 11:14 PM

Thanks, that worked great

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Primary Domain Name	spaguy	Shared Hosting Support	7	09-16-2008 11:51 AM
HG supports .com as primary, is .co.uk ok	cumro25	Shared Hosting Support	3	05-12-2008 04:58 AM
Euro + foreign languages	Templateshop	Pre-Sales Questions	3	09-13-2004 03:25 PM