|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
1200+ fellow developers rate and compare features of the top IDEs, like Visual Studio, Eclipse, RAD, Delphi and others, across 13 categories. Enjoy this FREE Download of the IDE User Satisfaction Study by Evans Data Corporation. Download Now!
|
|
#1
July 26th, 2003, 07:53 PM
|
|||
|
|||
|
How to override Unique Constraint?
//AS of now this problem has been solved.
 It's Saturday night and I am working my a$$ off on too many things (at the company site, of course). Anyway, my partner made the terrible mistake of placing a "UNIQUE CONSTRAINT" on a column that should be full of duplicate records. This is in Oracle, by the way. So now I have to unplace the unique constraint in order to insert some data. I tried to drop the table, but there were reference keys to other existing tables, so I dared not to mess with it too much. So how can I make a unique column not unique any more, as painless as possible? Last edited by vb.net : July 26th, 2003 at 07:57 PM.
|
|
#3
July 26th, 2003, 11:05 PM
|
|||
|
|||
|
alter table table-name disable constraint-name
or alter table table-name drop contstrain-name
|
|
#5
July 27th, 2003, 02:53 PM
|
|||
|
|||
|
You can rename a table in Oracle. From Oracle 9i and on can you rename a column.
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > How to override Unique Constraint? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
 |
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
