How to DROP index with Unique constraint?

Discussion in 'microsoft.public.sqlserver.ce' started by Jin, Jul 16, 2009.

  1. Jin

    Jin Guest

    What seems to be an easy task is giving me some major problems. I'm
    trying to drop an Index with Unique constraint in order to recreate
    it, but for the life of me, I cannot do it. The documentation
    indicates that a simple DROP INDEX statement cannot be used on Index
    having unique constraint, but there is no easy way for me to drop that
    constraint either (before attempting the drop the index again).
    Anyone run into similar issue, and if so, what are the right steps?

    Thanks in advance.

    BTW, using versin 3.1 of SQLCE.

    - Jin
     
    Jin, Jul 16, 2009
    #1
    1. Advertisements

  2. Did you try ALTER TABLE DROP CONSTRAINT?
     
    Laxmi Narsimha Rao Oruganti [MSFT], Jul 22, 2009
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.