sp_getProcedureColumns Column Type

Question

How do I find out what the value of the COLUMN_TYPE returned from sp_getProcedureColumns? The value returned is an shortInt.

There is nothing in the documentation for this system procedure.

Thanks,

Howard

Answer 1

It is equivalent to the ODBC function SQLProcedureColumns

Type = 1: Input

Type = 3: Result column, i.e. column in output cursor.

Those are the only two types that should be returned.