Click to Rate and Give Feedback
TechNet
TechNet Library
SQL Server
SQL Server 2008
Database Engine
Technical Reference
 sys.partition_schemes (Transact-SQL...

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (0)
Other versions are also available for the following:
SQL Server 2008 Books Online (June 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)

Requires membership in the public role. For more information, see Metadata Visibility Configuration.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker