sp_sproc_columns

Description

Returns information about a stored procedure’s input and return parameters.

Syntax

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

Parameters

procedure_name

is the name of the stored procedure. The use of wildcard characters in pattern matching is not supported.

procedure_owner

is the owner of the stored procedure. The use of wildcard characters in pattern matching is not supported. If no owner is specified, sp_sproc_columns returns all columns.

procedure_qualifier

is the name of the database. This can be either the current database or NULL.

column_name

is the name of the parameter about which you want information. If you do not supply a parameter name, sp_sproc_columns returns information about all input and return parameters for the stored procedure.

Usage

Permissions

Any user can execute sp_sproc_columns.