To find Partitioned table

SELECT partition_number,rows,object_name(object_id)

FROM sys.partitions s

WHERE EXISTS(SELECT NULL

                FROM sys.partitions s2

                WHERE s.object_id = s2.object_id

                AND partition_number > 1

                AND s.index_id = s2.index_id)