sys.partition_schemes (Transact-SQL)

sys.partition_schemes (Transact-SQL...

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (0)

Collapse All

Other versions are also available for the following:

SQL Server 2008 Books Online (October 2009)

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.