How do I get a list of all the partitioned tables in my database?
Which system tables/DMVs should I be looking at?
This query should give you what you want:
All tables have at least one partition, so if you are looking specifically for partitioned tables, then you'll have to filter this query based off of
Methinks a better query is as follows:
This looks at the 'proper' place to identify the partition scheme: