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