Returns information about stored procedure input and return
parameters.
Syntax
sp_sproc_columns sp_name [, sp_owner]
[, sp_qualifier] [, column_name]
or
sp_sproc_columns procedure_name [, procedure_owner]
[, procedure_qualifier] [, column_name]
Parameters
- sp_name or procedure_name – is the name of the stored procedure. Wildcard-character
search patterns are not supported.
- sp_owner or procedure_owner – is the owner of the stored procedure. Wildcard-character
search patterns are not supported.
- sp_qualifier or procedure_qualifier – is ignored. Leave blank or set to NULL.
- column_name – is the name of the parameter about which you want
information. If you do not supply a parameter name, this procedure
returns information about all input parameters.
Usage
This procedure corresponds to the ODBC function SQLProcedureColumns.
Note: In ECDA Option for ODBC, sp_sproc_columns returns
extra, unsolicited columns.