File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
EJB 3 in Action
this week in the
EJB and other Java EE Technologies
Dropping Unique Key
ford Darcy Jr
Joined: Jan 26, 2005
Mar 02, 2006 12:03:00
I have a table
. It has a primary key column ID and a unique key column ID2. I want to drop the unique key from column ID2.
Alter table test drop unique (ID2); is not working. How do I achieve this.
[ March 02, 2006: Message edited by: ford Darcy Jr ]
Joined: Mar 06, 2006
Mar 08, 2006 02:35:00
U have to use following command,
alter table [table_name] drop constraint [constraint_name]
If u dont have the constraint_name then use following command retrive it.
select * from user_constraints where table_name = 'TABLE_NAME'
Hope this helps.
It is sorta covered in the
JavaRanch Style Guide
subject: Dropping Unique Key
struts2 drop down - unique values
how to make the column unique?
hibernate : ternary association mapped by a map (like book page 347)
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014