Post reply

Dropping Primary Key Column Constrint

  • November 17, 2009 at 11:29 pm

    #217754

    Hi,

    How to delete Primary key created in design view

    of a table with 35 Million records

    how long it will take to drop it..

    Pls suggest me

  • November 18, 2009 at 12:26 am

    #1080709

    DBTeam (11/17/2009)

    how long it will take to drop it..

    How long is a piece of string?

    There's no simple answer. Depends on the size of the table (in MB), the other activity, the IO performance and a whole lot of other factors.

    Try it out on the dev system, see how long it takes.

    Edit: I suggest you don't use the design view, it'll likely time out. Write a script and run it in a query window.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 18, 2009 at 1:25 am

    #1080727

    Thank u so much for ur suggestion..

    I done that in query window..

    It took 1hr 40 min...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply