Table: dbo.parameters (Parameters)

Schema dbo
Name parameters
Title Parameters
Module Schema and Metadata

Function and procedure parameters.

Columns
PK Name Data type Null Attributes Description
1 parameter_id int Identity / Auto increment column Row ID.
Row ID.
Identity / Auto increment column
2 procedure_id int Parameter's procedure.
Parameter's procedure.
3 ordinal_position int Position of parameter in parameters list
Position of parameter in parameters list
4 parameter_mode nvarchar(10) IN, OUT, INOUT
IN, OUT, INOUT
5 name nvarchar(250) Parameter name in DBMS. "Returns" for functions output.
Parameter name in DBMS. "Returns" for functions output.
6 description nvarchar(MAX) Parameter description defined with Dataedo.
Parameter description defined with Dataedo.
7 datatype nvarchar(250) Column data type.
Column data type.
8 data_length nvarchar(20) Data length/precision as text. Depending on data type it can have differenent formats, e.g. "100", "5,4", "MAX" etc. Null if parameter has no length/precision defined.
Data length/precision as text. Depending on data type it can have differenent formats, e.g. "100", "5,4", "MAX" etc. Null if parameter has no length/precision defined.
9 status char(1) Default: 'A' 'D' if parameter was deleted from DBMS, 'A' otherwise
'D' if parameter was deleted from DBMS, 'A' otherwise
Default: 'A'
10 creation_date datetime Default: getdate() Standard row creation timestamp.
Standard row creation timestamp.
Default: getdate()
11 created_by nvarchar(100) Default: NULL Database/Dataedo username that created row.
Database/Dataedo username that created row.
Default: NULL
12 last_modification_date datetime Default: getdate() Standard row last update timestamp.
Standard row last update timestamp.
Default: getdate()
13 modified_by nvarchar(100) Default: NULL Database/Dataedo username that last updated row.
Database/Dataedo username that last updated row.
Default: NULL
Relations
Foreign table Primary table Join Title / Name / Description
dbo.parameters dbo.procedures dbo.parameters.procedure_id = dbo.procedures.procedure_id FK_parameters_procedures
dbo.parameters.procedure_id = dbo.procedures.procedure_id
FK_parameters_procedures
Unique keys
Key name Columns Description
PK_parameters parameter_id Table primary key.
Table primary key.
Triggers
Key name When Description
trg_parameters_Modify After Insert, Update Standard insert/update trigger setting last_modification_date, modified by columns
Standard insert/update trigger setting last_modification_date, modified by columns
Uses
Name
dbo.parameters (Parameters)
Exported: 2017-05-15 08:09, Last imported: 2017-04-06 15:30