Table: dbo.procedures (Procedures and Functions)

Schema dbo
Name procedures
Title Procedures and Functions
Module Schema and Metadata

Database stored procedures and functions.

 

Procedures and functions are distinguished by object_type column with 'PROCEDURE' and 'FUNCTION' values.

Columns
PK Name Data type Null Attributes Description
1 procedure_id int Identity / Auto increment column Row ID.
Row ID.
Identity / Auto increment column
2 database_id int Documentation which object is part of. Ref: databases.
Documentation which object is part of. Ref: databases.
3 schema nvarchar(250) DBMS schema name.
DBMS schema name.
4 name nvarchar(250) Object DBMS name.
Object DBMS name.
5 title nvarchar(250) Alternative object title defined with Dataedo.
Alternative object title defined with Dataedo.
6 description nvarchar(MAX) Procedure/function description defined with Dataedo.
Procedure/function description defined with Dataedo.
7 object_type nvarchar(100) Database object type. ''PROCEDURE' for procedures, 'FUNCTION' for functions.
Database object type. ''PROCEDURE' for procedures, 'FUNCTION' for functions.
8 definition nvarchar(MAX) Procedure/function script imported from DBMS.
Procedure/function script imported from DBMS.
9 status char(1) Default: 'A' 'D' if procedure/function was deleted from DBMS, 'A' otherwise
'D' if procedure/function was deleted from DBMS, 'A' otherwise
Default: 'A'
10 dbms_creation_date datetime Time procedure/function was created in DBMS.
Time procedure/function was created in DBMS.
11 dbms_last_modification_date datetime Time procedure/function was last updated in DBMS.
Time procedure/function was last updated in DBMS.
12 synchronization_date datetime Time of last object update/import from DBMS.
Time of last object update/import from DBMS.
13 synchronized_by nvarchar(100) Login of user that last updated/imported the object from DBMS.
Login of user that last updated/imported the object from DBMS.
14 creation_date datetime Default: getdate() Standard row creation timestamp.
Standard row creation timestamp.
Default: getdate()
15 created_by nvarchar(100) Default: NULL Database/Dataedo username that created row.
Database/Dataedo username that created row.
Default: NULL
16 last_modification_date datetime Default: getdate() Standard row last update timestamp.
Standard row last update timestamp.
Default: getdate()
17 modified_by nvarchar(100) Default: NULL Database/Dataedo username that last updated row.
Database/Dataedo username that last updated row.
Default: NULL
18 function_type nvarchar(100) Type of function as defined in DBMS, eg. "Table-valued", "Scalar-valued".
Type of function as defined in DBMS, eg. "Table-valued", "Scalar-valued".
19 exists_in_DBMS bit A flag which denotes if an object exists in DBMS. Used during synchronization.
A flag which denotes if an object exists in DBMS. Used during synchronization.
20 description_search nvarchar(MAX) Column used for searching, holds description as plain text. Description column contains HTML tags and images that would interfere searching.
Column used for searching, holds description as plain text. Description column contains HTML tags and images that would interfere searching.
Relations
Foreign table Primary table Join Title / Name / Description
dbo.procedures dbo.databases dbo.procedures.database_id = dbo.databases.database_id FK_procedures_database
dbo.procedures.database_id = dbo.databases.database_id
FK_procedures_database
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
dbo.procedures_modules dbo.procedures dbo.procedures_modules.procedure_id = dbo.procedures.procedure_id FK_procedures_modules_procedure
dbo.procedures_modules.procedure_id = dbo.procedures.procedure_id
FK_procedures_modules_procedure
Unique keys
Key name Columns Description
PK_procedures procedure_id Table primary key.
Table primary key.
Triggers
Key name When Description
trg_procedures_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.procedures (Procedures and Functions)
Used by
Name
dbo.procedures (Procedures and Functions)
Exported: 2017-05-15 08:09, Last imported: 2017-04-06 15:30