TechNet
Export (0) Print
Expand All

sys.partition_schemes (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

Contains a row for each Data Space that is a partition scheme, with type = PS.

Column nameData typeDescription
<inherited columns>Inherits columns from sys.data_spaces (Transact-SQL).
function_idintID of partition function used in the scheme.

For a list of columns that this view inherits, see sys.data_spaces (Transact-SQL)

Requires membership in the public role. For more information, see Metadata Visibility Configuration.

Catalog Views (Transact-SQL)
Querying the SQL Server System Catalog FAQ

Community Additions

ADD
Show:
© 2016 Microsoft