By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,852 Members | 2,200 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,852 IT Pros & Developers. It's quick & easy.

deferring/disabling unique index

P: n/a
Hi,

I need to know if there is a way to defer or disable a unique index on a
table during an update. One way would be to set indisunique to false,
perform update and then set to true. But, this seems to be an ugly
solution.

I've posted a similar message 6 months ago and at that time deferring
unique constraints was on a todo list. I wonder if this has been added
to 7.4.1 release. If not, what is the best way to disable an index on a
table?

Thanks.

Oleg

*************************************

This e-mail may contain privileged or confidential material intended for the named recipient only.
If you are not the named recipient, delete this message and all attachments.
Unauthorized reviewing, copying, printing, disclosing, or otherwise using information in this e-mail is prohibited.
We reserve the right to monitor e-mail sent through our network.

*************************************

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.