SQL-Articles
On Premise and Cloud Database Knowledge Base

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 *

*