Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Dropping Unique Key

 
ford Darcy Jr
Ranch Hand
Posts: 76
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have a table test. 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.

Thanks.
[ March 02, 2006: Message edited by: ford Darcy Jr ]
 
Mahesh Kuhile
Greenhorn
Posts: 6
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
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.

Thanks,
Mahesh
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic