Categories
DBA

Systables related to partitioning

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

sys.partition_schemes

sys.data_spaces

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

sys.tables

sys.indexes

sys.index_columns

To get partitioning information about a table or index

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

*