This will find partitioned tables
select distinct object_name(object_id) from sys.partitions
group by object_id, index_id
having COUNT(*) > 1
This will find the partitions for a specific table
SELECT *
FROM sys.partitions
WHERE OBJECT_ID = OBJECT_ID(‘<Schema>.<Table>’)