To View Table Partitions by Name
database #database#table
select Object_name(object_id) as TableName,*
from sys.partitions where object_id=object_id('tablename') select Object_name(object_id) as TableName,*
from sys.partitions where object_id=object_id('tablename')