sys.partition_schemes (Transact-SQL)

Contains a row for each Data Space that is a partition scheme, with type of PS.

Column name Data type Description

<inherited columns>


Inherits columns from sys.data_spaces (Transact-SQL).



ID of partition function used in the scheme.

For a list of columns that this view inherits, see sys.data_spaces (Transact-SQL)

See Also


Catalog Views (Transact-SQL)

Other Resources

Querying the SQL Server System Catalog FAQ

Help and Information

Getting SQL Server 2005 Assistance