Partitioned Tables and Columns

SELECT t.NAME AS TableName
 ,SCHEMA_NAME(T.schema_id) SchemaName
 ,ps.NAME AS PartitionScheme
 ,c.NAME
FROM sys.tables t
INNER JOIN sys.indexes i ON t.object_id = i.object_id
INNER JOIN sys.partition_schemes ps ON i.data_space_id = ps.data_space_id
INNER JOIN sys.index_columns ic ON (
  ic.partition_ordinal > 0
  AND ic.index_id = i.index_id
  AND ic.object_id = t.object_id
  )
INNER JOIN sys.columns c ON (
  c.object_id = ic.object_id
  AND c.column_id = ic.column_id
  )
WHERE i.index_id < 2