Edit

Schema Rowsets Changed for OLE DB Table-Valued Parameters in SQL Server Native Client

  • Article

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

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.

See Also

Table-Valued Parameters (OLE DB)
Use Table-Valued Parameters (OLE DB)