| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.partition_schemes (Transact-SQL) |
sys.partition_schemes (Transact-SQL) |
rwestMSFT |
randolphwest |
03/15/2017 |
sql |
system-objects |
reference |
|
|
|
>=aps-pdw-2016||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current||=fabric |
[!INCLUDE sql-asdbmi-asa-pdw-fabricse-fabricdw]
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.
Catalog Views (Transact-SQL)
Querying the SQL Server System Catalog FAQ