This documentation is archived and is not being maintained.

SQLProcedureColumns

SQLProcedureColumns returns one row reporting the return value attributes of all SQL Server stored procedures.

SQLProcedureColumns returns SQL_SUCCESS whether or not values exist for CatalogName, SchemaName, ProcName, or ColumnName parameters. SQLFetch returns SQL_NO_DATA when invalid values are used in these parameters.

SQLProcedureColumns can be executed on a static server cursor. An attempt to execute SQLProcedureColumns on an updatable (dynamic or keyset) cursor will return SQL_SUCCESS_WITH_INFO indicating that the cursor type has been changed.

The following table lists the columns returned by the result set and how they have been extended to handle the udt and xml data types through the SQL Native Client ODBC driver:

Column name Description

SS_UDT_CATALOG_NAME

Returns the name of the catalog containing the UDT (user-defined type).

SS_UDT_SCHEMA_NAME

Returns the name of the schema containing the UDT.

SS_UDT_ASSEMBLY_TYPE_NAME

Returns the assembly-qualified name of the UDT.

SS_XML_SCHEMACOLLECTION_CATALOG_NAME

Returns the name of the catalog where an XML schema collection name is defined. If the catalog name cannot be found, then this variable contains an empty string.

SS_XML_SCHEMACOLLECTION_SCHEMA_NAME

Returns the name of the schema where an XML schema collection name is defined. If the schema name cannot be found, then this variable contains an empty string.

SS_XML_SCHEMACOLLECTION_NAME

Returns the name of an XML schema collection. If the name cannot be found, then this variable contains an empty string.

Show: