Get List of Partitioned Tables in SQL Server

Table partitions have lot of benefits, although they can not be used for direct query mode of the latest SSAS Tabular cubes. The script copied here displays a list of all partitioned tables in a database

select distinct t.name
from sys.partitions p
inner join sys.tables t
on p.object_id = t.object_id
where p.partition_number <> 1

Copied from http://dba.stackexchange.com/questions/14996/how-do-i-get-a-list-of-all-the-partitioned-tables-in-my-database