Export (0) Print
Expand All

sys.partition_schemes (Transact-SQL)


Applies To: SQL Server 2014, SQL Server 2016 Preview

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

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Data Warehouse Public Preview.

Column name

Data type


<inherited columns>


Inherits columns from sys.data_spaces (Transact-SQL).



ID 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft