How to assign a primary key

[archulu]

hai
this is sonu. i am new to thiss. i have a doubt in creating table. in creating tables we are taking some key words. my doubt is how asighn key words (primary and forign key) to names in a table.
ex:
i am creating 3 tables about employee
leave table, leavetype table, manger table
in this 3 tables emp code is primary key
and leave date is forign key

Q: how to create table emp code as primary key and leave date as forighn key.


please help to me

[archulu]

any way thanks to all.
i got the answer from books


for primary key assighn ex:

CREATE TABLE Leavetable ( emp_code varchar(25) primary key NOT NULL, fdate date, update date, first_half date, second_half date, no_of_days integer [3] );
 

for foreighn key asighn ex:

 CREATE TABLE Leavetype ( emp_code varchar(25) references leavetable(emp_code), date date, type_of_leave varchar, reason char [50] );
 

thanks again to all

[michaelb]

any way thanks to all.
I got the answer from books
... ... ...

You did the right thing - If all fails, read the manual! :)

You may also want to look at the Constraints doc.