DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Disable index

  1. #1
    Join Date
    Dec 2000
    Posts
    12
    How to disable the Unique index ?

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    You can disable a unique constraint, but you can't disable a unique index. I mean if you have a unique key constraint with nonunique index under it you can defer unique values enforcement. But if the index is created as unique it will allways require unique values unless you drop it.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width