title

sys.partition_schemes (Transact-SQL)

description

sys.partition_schemes (Transact-SQL)

author

rwestMSFT

ms.author

randolphwest

ms.date

03/15/2017

ms.service

sql

ms.subservice

system-objects

ms.topic

reference

f1_keywords

partition_schemes_TSQL

partition_schemes

sys.partition_schemes_TSQL

sys.partition_schemes

helpviewer_keywords

sys.partition_schemes catalog view

dev_langs

TSQL

monikerRange

>=aps-pdw-2016||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current||=fabric

sys.partition_schemes (Transact-SQL)

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.