composite key syntax. How can I fix this?
View Single Post
03-31-2010, 04:19 PM
Join Date: Sep 2007
Originally Posted by
isn't that primary key that referring to another primary key in another table is called as 'composite key'?
i'm not not really agree when you said that i'm actually wanted to declare is a unique ID. or, am i wrong in understanding this 'composite key' term? if so, someone please explain to me...
i'm sorry, i'm not expert in database i just started to learn it and stil learn about it.
however, here's the relationship below and i really thinks what i'm trying to achieve is not foreign key but composite key..
A primary key can never refer to another table, it is used exclusively to identify each row. What you are looking for is a foreign key, use google to lean about those.
View Public Profile
Send a private message to Village Idiot
Find More Posts by Village Idiot