Below listed are the systables which can be used to get information regarding partitioned tables, indexes are views.
Systables
|
Description
|
sys.partition_functions | To get information about individual partition functions |
sys.partition_parameters | To get information about individual parameters of partition functions |
sys.partition_range_values | To get information about the boundary values of a partition function |
To get information about all the partition schemes in a database | |
sys.destination_data_spaces | To get information about individual partition schemes |
sys.partitions | To get information about all the partitions in a database |
To get partitioning information about a table or index |
Leave a Reply