• Was more looking for table definition.

    What you can do is join sys.indexes to sys.partitions and filter on objectname of parentobjectid =yourtable And indindex_id <2.

    This will show you your table and the partitions.

    If you only have one row then the table is not partitioned.

    If you have many rows then look at the rowcount to see if the distribution is what you expect.

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]