Home Forums SQL Server 2008 SQL Server 2008 Administration Partition including refernce tables and multiple keys RE: Partition including refernce tables and multiple keys

  • January 7, 2013 at 3:30 pm

    #1574551

    Minaz Amin (1/7/2013)

    Hi All,

    We are planning to partition our table which have many reference tables. Is it possible to have multiple keys as partitons keys?

    No. You only designate one partition key but you can have additional unique constraints which you can then refer to by foreign key.

    Just curious, why are you planning to partition your table?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato