A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
How to delete foreign key without name in Oracle
Joined: Nov 18, 2013
Jan 19, 2014 10:56:43
I forgot to give name of foreign key constraint.
I added Foreign key constraint in the following way:
ALTER TABLE Result1
ADD foreign key (stud_id) references Student(stud_id);
How I can drop the above foreign key constraint...???
Joined: Dec 25, 2013
Jan 19, 2014 12:37:24
Query the user_constraints table to get the constraint_name.
Then run an alter table query that will drop that constraint.
It is sorta covered in the
JavaRanch Style Guide
subject: How to delete foreign key without name in Oracle
Syntax error for Access Database
Need clarification in Many to one Mapping- Please help.
a different object with the same identifier value was already associated with the session: [ValueObj
error: Parameter index out of range (3 > number of parameters, which is 2).
complex table column type
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014