As modelling of data when a table possesses two foreign keys, these two work
as primary key avoiding duplications...
As I make those FOREIGN KEY in SQL for them to work like PRIMARY KEY...
Here is the Example
CREATE TABLE <TABLE_NAME>
(
KET_1 REFERENCES <>,
KEY_2 REFERENCES <>,
PRIMARY KEY (KEY_1,KEY_2)
)
thanks and regards
Chandra
"Frank Dulk" wrote:
> As modelling of data when a table possesses two foreign keys, these two work
> as primary key avoiding duplications...
> As I make those FOREIGN KEY in SQL for them to work like PRIMARY KEY...
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment