title: Query to check partitions of a table (not index) in SQLServer 2008
body: <p>I'm trying to write a query that would return the partitions of a Table. It seems that sys.partitions returns only the partitions associated with indexes. Where can I find partitions associated with the table only?</p>
  
  <p><a href="https://i.stack.imgur.com/CLLtO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CLLtO.png" alt="enter image description here"></a></p>
  
  <p>I wish to retrieve the information related to <strong>Compression > Partitions using page compression</strong> and <strong>Number of Partitions</strong>.</p>