foreign key

Hi all,

Can any one please let me know the alternative of
"foreign key" referential integrity.  I'v pg 6.5.2
under Linux.  I'm not able to use the foreign key
reference.  when I say "create table emp (id int, dno
int foreign key references dept(dno));

the error message points to "foreign" key.  Can any
one help me in this solving theis problem.






=====
Thanks.
Soundar.
__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com