sp_sproc_columns

Returns information about stored procedure input and return parameters.

DirectConnect supports syntax for SQL Server versions 10 and 11.

sp_sproc_columns sp_name [, sp_owner]
 [, sp_qualifier] [, column_name]

or

sp_sproc_columns procedure_name [, procedure_owner]
 [, procedure_qualifier] [, column_name]

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.

This procedure corresponds to the ODBC function SQLProcedureColumns.

In DirectConnect, sp_sproc_columns returns extra, unsolicited columns.