Post reply

Look like typical..............

  • June 9, 2011 at 4:43 pm

    #239040

    Can any one help me to create partition on existing table. I have seen so many examples and links creating partition on new table. But i can't find any links , how to create partition on existing table. So if any one help me that would be great. Thank you.

  • June 10, 2011 at 7:52 am

    #1337001

    From memory all you need to do is drop the clustered index on the table (most likely the primary key) and recreate it specifying the partition scheme in the on clause. Cant seem to find an example script at the moment but I'll try and dig one out.

    See section H example in the link below:

    http://msdn.microsoft.com/en-us/library/ms188783.aspx

    MCITP SQL 2005, MCSA SQL 2012

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

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