Results 1 to 2 of 2

Thread: Table Partition

  1. #1
    Join Date
    Nov 2005
    Posts
    6

    Unanswered: Table Partition

    Hi

    Please help me how to do the Horizontal table partition??
    I have to split the table in to multiple sub tables with same columns and less rows and then I have to use each sub table.

    Thanks you in advance....

    Regards
    LakshmiPK

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    I don't think that there is any magic to this in SQL Server; it's not like in Oracle or anything. Really you are creating multiple tables with the same schema. You might want to check out the following link, however because it explains about using a partitioned view (so you can access the individual underlying tables through a single object).

    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

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