RE: Is it possible to have primary key and foreign key...
yes it possible 2 have foriegn key constraint on the same table where there is a primary key.this is can done by adding a constraint to the table using alter table tblname . the refernce column and table being the base table. thus one table can have both primary key as well as foreign key constraint.
RE: Is it possible to have primary key and foreign key...
Dear Vivek, If I understand your question well, you mean to say that "is there any possibility to have both primary & foreign keys in the same table". Well, the answer is No. The foreign key (by definition) in a table is the key which is the reference of primary key of different table i.e. the foreign key in a table is the primary key of another table. Therefore, in order to make use of foreign key concept, the tables should be different (one containing primary key while other containing foreign key). (Please let me know for any issues).
