meta_SPParameters
Returns the parameters defined for the current stored procedures in systems being tracked by MDS. Corresponds to the relationship SPHasParameters.
Column |
Data Type |
Values |
|
SystemName |
VARCHAR(256) |
|
|
DatabaseName |
VARCHAR(128) |
|
|
StoredProcedureName |
VARCHAR(128) |
|
|
ParameterName |
VARCHAR(128) |
|
|
ParameterPositionID |
SMALLINT |
|
|
ParameterType |
VARCHAR(12) |
|
|
ParameterDataType |
CHAR(2) |
|
|
ParameterDataTypeA |
VARCHAR(29) |
|
|
ParameterLength |
INTEGER |
|
|
CharType |
SMALLINT |
|
|
CharacterSet |
VARCHAR(8) |
|
|
ParameterComment |
VARCHAR(255) |
|
|
SPLoid |
INTEGER |
|
|
ParameterLoid |
INTEGER |
|
|
RowTypeDatabaseName |
VARCHAR(128) |
|
|
RowTypeTableName |
VARCHAR(128) |
|