| title | Schema rowsets, OLE DB Table-Valued Parameters | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/06/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine, sql-database, sql-data-warehouse, pdw | ||
| ms.reviewer | |||
| ms.technology | native-client | ||
| ms.topic | reference | ||
| helpviewer_keywords |
|
||
| ms.assetid | 581e3ead-53db-44da-8718-f3fc4b5108f1 | ||
| author | markingmyname | ||
| ms.author | maghan | ||
| monikerRange | >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md]
The following are the schema rowsets that have been changed or added to support table-valued parameters.
| Schema rowset | Description |
|---|---|
| DBSCHEMA_PROCEDURE_PARAMETERS | Two new columns were added at the end of the rowset named SS_TYPE_CATALOG_NAME and SS_TYPE_SCHEMANAME. These columns could be re-used for future types. The TYPE_NAME and LOCAL_TYPE_NAME columns will contain the name of the table-valued parameter TABLE type. The DATA_TYPE column will have value DBTYPE_TABLE = 143 for table-valued parameters. |
| DBSCHEMA_TABLE_TYPES | This rowset was added to support table-valued parameters. It is identical to DBSCHEMA_TABLES, except that it returns metadata only for table types, rather than for tables, views, or synonyms. The TABLE_TYPE column will have the value 'TABLE TYPE'. |
| DBSCHEMA_TABLE_TYPE_PRIMARY_KEYS | This rowset was added to support table-valued parameters. It is identical to DBSCHEMA_PRIMARY_KEYS, except that it returns primary keys metadata only for table types, rather than for tables. |
| DBSCHEMA_TABLE_TYPE_COLUMNS | This rowset was added to support table-valued parameters. It is identical to DBSCHEMA_COLUMNS, except that it returns column metadata only for table types, rather than for tables, views, or synonyms. |
Table-Valued Parameters (OLE DB)
Use Table-Valued Parameters (OLE DB)