How to define Foreign Keys

ysuryawanshi_mcs · Posted: Sat Apr 01, 2006 4:30 pm

HOW TO DEFINE FOREIGN KEYS

WARNING: TITLE EDITED

martin9 · Posted: Sat Apr 01, 2006 5:13 pm

hy ysuryawanshi_mcs,

while creating any table, you can define foreignkeys
pointing to the depending table.

1. define the foreignkeys as fields in your table

2. after the columns, you define the foreignkeys clause
--> almost the same, if you define a primary key clause...

martin9

perez_a · New User Joined: 02 Feb 2006 Posts: 25 Location: Italy

HI ysuryawanshi_mcs,
HERE U ARE AN EXAMPLE:

CREATE TABLE EXAMPLE
( EXA_NAME CHAR(10)
EXA_SEX CHAR(1)
CONSTRAINT
FK01 FOREIGN KEY (EXA_NAME)
REFERENCES ANAGRAPH (ANA_NAME)
);

WHERE ANAGRAPH IS A TABLE JUST CREATED AND ANA_NAME IS PRIMARY KEY FOR IT.
HAVE A NICE DAY perez_a