sys.partitions (Transact-SQL)
Contains a row for each partition of all the tables and most types of indexes in the database. Special index types like Full-Text, Spatial, and XML are not included in this view. All tables and indexes in SQL Server contain at least one partition, whether or not they are explicitly partitioned.
Column name |
Data type |
Description |
|---|---|---|
partition_id |
bigint |
Indicates the partition ID. Is unique within a database. |
object_id |
int |
Indicates the ID of the object to which this partition belongs. Every table or view is composed of at least one partition. |
index_id |
int |
Indicates the ID of the index within the object to which this partition belongs.
|
partition_number |
int |
Is a 1-based partition number within the owning index or heap. For non-partitioned tables and indexes, the value of this column is 1. |
hobt_id |
bigint |
Indicates the ID of the data heap or B-tree that contains the rows for this partition. |
rows |
bigint |
Indicates the approximate number of rows in this partition. |
filestream_filegroup_id |
smallint |
Indicates the ID of the FILESTREAM filegroup stored on this partition. |
data_compression |
tinyint |
Indicates the state of compression for each partition: 0 = NONE 1 = ROW 2 = PAGE 3 = COLUMNSTORE Note Full text indexes will be compressed in any edition of SQL Server. |
data_compression_desc |
nvarchar(60) |
Indicates the state of compression for each partition. Possible values are NONE, ROW, PAGE, and COLUMNSTORE. |
Permissions
Requires membership in the public role. For more information, see Metadata Visibility Configuration.
See Also
Reference
Object Catalog Views (Transact-SQL)