How to Drop a foreign key constraint which was created along with the table creation??

I have created a table with a foreign key. tat is i created the foreign key in the "CREATE TABLE" stmt itself. how to drop this foreign key.??

alter table table_name drop constraint FK_constraint_name;

and if u dnt know the foreign key name then just insert any row that will violate the constraint then u will get error from
system stating
cannot validate (SCOTT.FK_DEPTID) - parent keys not found

here fk_deptid is the foreign key
n then u can use the said command.

abhisheksingh wrote:and if u dnt know the foreign key name then just insert any row that will violate the constraint then u will get error from
system stating
cannot validate (SCOTT.FK_DEPTID) - parent keys not found

here fk_deptid is the foreign key
n then u can use the said command.

yes.. it works. thx.