sys.partition_schemes (Transact-SQL)
Applies to: SQL Server Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric 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
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for