ProcedureParametersColumns Class

Column names for result table from the built-in stored procedure DB_ADMIN.GET_PROCEDURE_COLUMNS and DataStoreConnection.GetSchema(MetaDataCollectionName.ProcedureParameters).

Class Hierarchy

Pascal

ProcedureParametersColumns = class;

C++

class ProcedureParametersColumns;

File

ProcedureParametersColumns.cs

Description

Column names for result table from the built-in stored procedure DB_ADMIN.GET_PROCEDURE_COLUMNS and DataStoreConnection.GetSchema(MetaDataCollectionName.ProcedureParameters).

The columns of the result table are:

Constant	Description
CatalogName	Used to access the CatalogName column in the ProcedureParameters metadata collection.The data in this column specifies the catalog name.
SchemaName	Used to access the SchemaName column in the ProcedureParameters metadata collection. The data in this column specifies the schema name.
ProcedureName	Used to access the ProcedureName column in the ProcedureParameters metadata collection. The data in this column specifies the procedure name.
ParameterName	Used to access the ParameterName column in the ProcedureParameters metadata collection. The data in this column specifies the parameter name.
ParameterMode	Used to access the ParameterMode column in the ProcedureParameters metadata collection. The data in this column specifies the parameter mode: IN, OUT, INOUT, RESULT.
TypeName	Used to access the TypeName column in the ProcedureParameters metadata collection. The data in this column specifies the database specific data type name.
Precision	Used to access the Precision column in the ProcedureParameters metadata collection. The data in this column specifies the precision of this type. For a string data type, this is the maximum number of characters. For a decimal types, this is the maximum number digits including digits from the scale.
Scale	Used to access the Scale column in the ProcedureParameters metadata collection. The data in this column specifies the scale of a decimal type.
Ordinal	Used to access the Ordinal column in the ProcedureParameters metadata collection. The data in this column specifies the parameter number starting with 1.
IsNullable	Used to access the IsNullable column in the ProcedureParameters metadata collection. The data in this column specifies that the procedure parameter can accept NULL values.
DbxDataType	Used to access the DbxDataType column in the ProcedureParameters metadata collection. The data in this column specifies the DBX data type.
IsFixedLength	Used to access the IsFixedLength column in the ProcedureParameters metadata collection. The data in this column specifies that the procedure parameter holds fixed length data.
IsUnicode	Used to access the IsUnicode column in the ProcedureParameters metadata collection. The data in this column specifies that the procedure parameter can hold unicode characters.
IsLong	Used to access the IsLong column in the ProcedureParameters metadata collection. The data in this column specifies that the procedure parameter is blob data type.
IsUnsigned	Used to access the IsUnsigned column in the ProcedureParameters metadata collection. The data in this column specifies that the procedure parameter is unsigned numeric type.