Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
sys.partition_schemes (Transact-SQL)
Applies to: 👁 Image
SQL Server 👁 Image
Azure SQL Managed Instance 👁 Image
Azure Synapse Analytics 👁 Image
Analytics Platform System (PDW) 👁 Image
SQL analytics endpoint in Microsoft Fabric 👁 Image
Warehouse in Microsoft Fabric
Contains a row for each Data Space that is a partition scheme, with type = PS.
| Column name | Data type | Description |
|---|---|---|
| <inherited columns> | Inherits columns from sys.data_spaces (Transact-SQL). | |
| function_id | int | ID of partition function used in the scheme. |
For a list of columns that this view inherits, see sys.data_spaces (Transact-SQL)
Permissions
Requires membership in the public role. For more information, see Metadata Visibility Configuration.
See Also
Catalog Views (Transact-SQL)
Querying the SQL Server System Catalog FAQ
Feedback
Was this page helpful?