dbo.procedures (Procedures and Functions)

Dataedo repository 7

- Dataedo repository 7
  - Modules
  - Tables

Documentation	Dataedo repository 7
Schema	dbo
Name	procedures
Title	Procedures and Functions
Module	Schema and Metadata
Type	Schema
Status	Active

Database stored procedures and functions.

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

Columns

		Name	Data type	Attributes	References	Description	Type	Status
	1	procedure_id	int	Identity		Row id	Metadata	Active
Row id Identity Type: Metadata Status: Active
	2	database_id	int		dbo.databases (Documentations)	Documentation which object is part of	Metadata	Active
Documentation which object is part of References: dbo.databases (Documentations) Type: Metadata Status: Active
	3	schema	nvarchar(250)			DBMS schema name	Schema	Active
DBMS schema name Type: Schema Status: Active
	4	name	nvarchar(250)			Object DBMS name	Schema	Active
Object DBMS name Type: Schema Status: Active
	5	object_type	nvarchar(100)			Database object type: PROCEDURE - procedure, FUNCTION - function	Schema	Active
Database object type: PROCEDURE - procedure, FUNCTION - function Type: Schema Status: Active
	6	subtype	nvarchar(100)			Procedure/function type. For procedures: PROCEDURE - regular stored procedure PACKAGE - packages in Oracle For funcitons: FUNCTION - regular user defined function METHOD - methods in Db2	Schema	Active
Procedure/function type. For procedures: PROCEDURE - regular stored procedure PACKAGE - packages in Oracle For funcitons: FUNCTION - regular user defined function METHOD - methods in Db2 Type: Schema Status: Active
	7	source	nvarchar(50)	Default: N'DBMS'		Source of the row: DBMS - imported from database, USER - manual defined by user in Dataedo repository	Metadata	Active
Source of the row: DBMS - imported from database, USER - manual defined by user in Dataedo repository Default: N'DBMS' Type: Metadata Status: Active
	8	status	char(1)	Default: 'A'		'D' if procedure/function was deleted from DBMS, 'A' otherwise	Metadata	Active
'D' if procedure/function was deleted from DBMS, 'A' otherwise Default: 'A' Type: Metadata Status: Active
	9	title	nvarchar(250)			Object title/alias in Dataedo repository	Documentation	Active
Object title/alias in Dataedo repository Type: Documentation Status: Active
	10	description	nvarchar(MAX)			Procedure/function description defined with Dataedo	Documentation	Active
Procedure/function description defined with Dataedo Type: Documentation Status: Active
	11	description_plain	nvarchar(MAX)			Holds description in plain text only, withouth HTML tags	Documentation	Active
Holds description in plain text only, withouth HTML tags Type: Documentation Status: Active
	12	description_search	nvarchar(MAX)			Holds description in plain text and lower case. Column used for searching.	Documentation	Active
Holds description in plain text and lower case. Column used for searching. Type: Documentation Status: Active
	13	function_type	nvarchar(100)			Type of function as defined in DBMS, eg. "Table-valued", "Scalar-valued"	Schema	Active
Type of function as defined in DBMS, eg. "Table-valued", "Scalar-valued" Type: Schema Status: Active
	14	language	nvarchar(100)			Function/procedure language code if relevant	Schema	Active
Function/procedure language code if relevant Type: Schema Status: Active
	15	definition	nvarchar(MAX)			Procedure/function script imported from DBMS	Schema	Active
Procedure/function script imported from DBMS Type: Schema Status: Active
	16	dbms_creation_date	datetime			Time procedure/function was created in DBMS	Schema	Active
Time procedure/function was created in DBMS Type: Schema Status: Active
	17	dbms_last_modification_date	datetime			Time procedure/function was last updated in DBMS	Metadata	Active
Time procedure/function was last updated in DBMS Type: Metadata Status: Active
	18	synchronization_date	datetime			Time of last object update/import from DBMS	Metadata	Active
Time of last object update/import from DBMS Type: Metadata Status: Active
	19	synchronized_by	nvarchar(100)			Login of user that last updated/imported the object from DBMS	Metadata	Active
Login of user that last updated/imported the object from DBMS Type: Metadata Status: Active
	20	field1	nvarchar(MAX)			Custom field 1	Documentation	Active
Custom field 1 Type: Documentation Status: Active
	21	field2	nvarchar(MAX)			Custom field 2	Documentation	Active
Custom field 2 Type: Documentation Status: Active
	22	field3	nvarchar(MAX)			Custom field 3	Documentation	Active
Custom field 3 Type: Documentation Status: Active
	23	field4	nvarchar(MAX)			Custom field 4	Documentation	Active
Custom field 4 Type: Documentation Status: Active
	24	field5	nvarchar(MAX)			Custom field 5	Documentation	Active
Custom field 5 Type: Documentation Status: Active
	25	field6	nvarchar(MAX)			Custom field 6	Documentation	Active
Custom field 6 Type: Documentation Status: Active
	26	field7	nvarchar(MAX)			Custom field 7	Documentation	Active
Custom field 7 Type: Documentation Status: Active
	27	field8	nvarchar(MAX)			Custom field 8	Documentation	Active
Custom field 8 Type: Documentation Status: Active
	28	field9	nvarchar(MAX)			Custom field 9	Documentation	Active
Custom field 9 Type: Documentation Status: Active
	29	field10	nvarchar(MAX)			Custom field 10	Documentation	Active
Custom field 10 Type: Documentation Status: Active
	30	field11	nvarchar(MAX)			Custom field 11	Documentation	Active
Custom field 11 Type: Documentation Status: Active
	31	field12	nvarchar(MAX)			Custom field 12	Documentation	Active
Custom field 12 Type: Documentation Status: Active
	32	field13	nvarchar(MAX)			Custom field 13	Documentation	Active
Custom field 13 Type: Documentation Status: Active
	33	field14	nvarchar(MAX)			Custom field 14	Documentation	Active
Custom field 14 Type: Documentation Status: Active
	34	field15	nvarchar(MAX)			Custom field 15	Documentation	Active
Custom field 15 Type: Documentation Status: Active
	35	field16	nvarchar(MAX)			Custom field 16	Documentation	Active
Custom field 16 Type: Documentation Status: Active
	36	field17	nvarchar(MAX)			Custom field 17	Documentation	Active
Custom field 17 Type: Documentation Status: Active
	37	field18	nvarchar(MAX)			Custom field 18	Documentation	Active
Custom field 18 Type: Documentation Status: Active
	38	field19	nvarchar(MAX)			Custom field 19	Documentation	Active
Custom field 19 Type: Documentation Status: Active
	39	field20	nvarchar(MAX)			Custom field 20	Documentation	Active
Custom field 20 Type: Documentation Status: Active
	40	field21	nvarchar(MAX)			Custom field 21	Documentation	Active
Custom field 21 Type: Documentation Status: Active
	41	field22	nvarchar(MAX)			Custom field 22	Documentation	Active
Custom field 22 Type: Documentation Status: Active
	42	field23	nvarchar(MAX)			Custom field 23	Documentation	Active
Custom field 23 Type: Documentation Status: Active
	43	field24	nvarchar(MAX)			Custom field 24	Documentation	Active
Custom field 24 Type: Documentation Status: Active
	44	field25	nvarchar(MAX)			Custom field 25	Documentation	Active
Custom field 25 Type: Documentation Status: Active
	45	field26	nvarchar(MAX)			Custom field 26	Documentation	Active
Custom field 26 Type: Documentation Status: Active
	46	field27	nvarchar(MAX)			Custom field 27	Documentation	Active
Custom field 27 Type: Documentation Status: Active
	47	field28	nvarchar(MAX)			Custom field 28	Documentation	Active
Custom field 28 Type: Documentation Status: Active
	48	field29	nvarchar(MAX)			Custom field 29	Documentation	Active
Custom field 29 Type: Documentation Status: Active
	49	field30	nvarchar(MAX)			Custom field 30	Documentation	Active
Custom field 30 Type: Documentation Status: Active
	50	field31	nvarchar(MAX)			Custom field 31	Documentation	Active
Custom field 31 Type: Documentation Status: Active
	51	field32	nvarchar(MAX)			Custom field 32	Documentation	Active
Custom field 32 Type: Documentation Status: Active
	52	field33	nvarchar(MAX)			Custom field 33	Documentation	Active
Custom field 33 Type: Documentation Status: Active
	53	field34	nvarchar(MAX)			Custom field 34	Documentation	Active
Custom field 34 Type: Documentation Status: Active
	54	field35	nvarchar(MAX)			Custom field 35	Documentation	Active
Custom field 35 Type: Documentation Status: Active
	55	field36	nvarchar(MAX)			Custom field 36	Documentation	Active
Custom field 36 Type: Documentation Status: Active
	56	field37	nvarchar(MAX)			Custom field 37	Documentation	Active
Custom field 37 Type: Documentation Status: Active
	57	field38	nvarchar(MAX)			Custom field 38	Documentation	Active
Custom field 38 Type: Documentation Status: Active
	58	field39	nvarchar(MAX)			Custom field 39	Documentation	Active
Custom field 39 Type: Documentation Status: Active
	59	field40	nvarchar(MAX)			Custom field 40	Documentation	Active
Custom field 40 Type: Documentation Status: Active
	60	creation_date	datetime	Default: getdate()		Standard row creation timestamp	Metadata	Active
Standard row creation timestamp Default: getdate() Type: Metadata Status: Active
	61	created_by	nvarchar(1024)	Default: suser_sname()		Dataedo username that created row	Metadata	Active
Dataedo username that created row Default: suser_sname() Type: Metadata Status: Active
	62	last_modification_date	datetime	Default: getdate()		Standard row last update timestamp	Metadata	Active
Standard row last update timestamp Default: getdate() Type: Metadata Status: Active
	63	modified_by	nvarchar(1024)	Default: suser_sname()		Dataedo username that last updated row	Metadata	Active
Dataedo username that last updated row Default: suser_sname() Type: Metadata Status: Active
	64	source_id	int			For internal use only	Internal	Active
For internal use only Type: Internal Status: Active
	65	temp_sync_status	bit	Default: 0		For internal use only	Internal	Active
For internal use only Default: 0 Type: Internal Status: Active
	66	exists_in_DBMS	bit			For internal use only	Internal	Active
For internal use only Type: Internal Status: Active
	67	update_id	int		dbo.schema_updates (Imports/Updates)	Id of the last schema import/update from source database where element was created/modified	Metadata	Active
Id of the last schema import/update from source database where element was created/modified References: dbo.schema_updates (Imports/Updates) Type: Metadata Status: Active

Relations

Foreign table	Primary table	Join	Title / Name / Description
dbo.procedures (Procedures and Functions)	dbo.databases (Documentations)	dbo.procedures.database_id = dbo.databases.database_id	FK_procedures_database
dbo.procedures.database_id = dbo.databases.database_id Name: FK_procedures_database
dbo.procedures (Procedures and Functions)	dbo.schema_updates (Imports/Updates)	dbo.procedures.update_id = dbo.schema_updates.update_id	fk_procedures_schema_updates
dbo.procedures.update_id = dbo.schema_updates.update_id Name: fk_procedures_schema_updates
dbo.parameters (Parameters)	dbo.procedures (Procedures and Functions)	dbo.parameters.procedure_id = dbo.procedures.procedure_id	FK_parameters_procedures
dbo.parameters.procedure_id = dbo.procedures.procedure_id Name: FK_parameters_procedures
dbo.parameters_changes	dbo.procedures (Procedures and Functions)	dbo.parameters_changes.procedure_id = dbo.procedures.procedure_id	fk_parameters_changes_procedures
dbo.parameters_changes.procedure_id = dbo.procedures.procedure_id Name: fk_parameters_changes_procedures
dbo.procedures_changes	dbo.procedures (Procedures and Functions)	dbo.procedures_changes.procedure_id = dbo.procedures.procedure_id	fk_procedures_changes_procedures
dbo.procedures_changes.procedure_id = dbo.procedures.procedure_id Name: fk_procedures_changes_procedures
dbo.procedures_modules (Procedures-modules)	dbo.procedures (Procedures and Functions)	dbo.procedures_modules.procedure_id = dbo.procedures.procedure_id	FK_procedures_modules_procedure
dbo.procedures_modules.procedure_id = dbo.procedures.procedure_id Name: 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_change_track_insert	After Insert	Schema change tracking trigger
-- ============================================= -- Description: Insert procedure's changes to schema change tracking tables -- ============================================= CREATE TRIGGER [trg_procedures_change_track_insert] ON [procedures] FOR INSERT AS -- skip manual objects created through Dataedo application -- or first documentation import to Dataedo application IF EXISTS ( SELECT TOP (1) 1 FROM [inserted] WHERE [source] = 'USER' ) OR EXISTS ( SELECT TOP (1) 1 FROM [inserted] [i] JOIN [schema_updates] [u] ON [u].[update_id] = [i].[update_id] AND [u].[type] = 'IMPORT' ) BEGIN RETURN; END; INSERT INTO [procedures_changes] ([database_id], [procedure_id], [schema], [name], [object_type], [definition], [function_type], [subtype], [operation], [dbms_last_modification_date], [valid_from], [update_id] ) SELECT [i].[database_id], [i].[procedure_id], [i].[schema], [i].[name], [i].[object_type], [i].[definition], [i].[function_type], [i].[subtype], 'ADDED', GETDATE(), [i].[dbms_last_modification_date], [i].[update_id] FROM [inserted] [i];
Schema change tracking trigger
-- ============================================= -- Description: Insert procedure's changes to schema change tracking tables -- ============================================= CREATE TRIGGER [trg_procedures_change_track_insert] ON [procedures] FOR INSERT AS -- skip manual objects created through Dataedo application -- or first documentation import to Dataedo application IF EXISTS ( SELECT TOP (1) 1 FROM [inserted] WHERE [source] = 'USER' ) OR EXISTS ( SELECT TOP (1) 1 FROM [inserted] [i] JOIN [schema_updates] [u] ON [u].[update_id] = [i].[update_id] AND [u].[type] = 'IMPORT' ) BEGIN RETURN; END; INSERT INTO [procedures_changes] ([database_id], [procedure_id], [schema], [name], [object_type], [definition], [function_type], [subtype], [operation], [dbms_last_modification_date], [valid_from], [update_id] ) SELECT [i].[database_id], [i].[procedure_id], [i].[schema], [i].[name], [i].[object_type], [i].[definition], [i].[function_type], [i].[subtype], 'ADDED', GETDATE(), [i].[dbms_last_modification_date], [i].[update_id] FROM [inserted] [i];
	trg_procedures_change_track_update	After Update	Schema change tracking trigger
-- ============================================= -- Description: Insert procedure's changes to schema change tracking tables -- ============================================= CREATE TRIGGER [trg_procedures_change_track_update] ON [procedures] FOR UPDATE AS -- skip manual objects created through Dataedo application IF EXISTS ( SELECT TOP (1) 1 FROM [INSERTED] WHERE [source] = 'USER' ) BEGIN RETURN; END; -- check if object property change IF EXISTS ( SELECT TOP (1) 1 FROM [inserted] [i] INNER JOIN [deleted] [d] ON [i].[procedure_id] = [d].[procedure_id] WHERE ISNULL([d].[schema],'') <> [i].[schema] OR ISNULL([d].[name],'') <> [i].[name] OR ISNULL([d].[object_type],'') <> [i].[object_type] OR ISNULL([d].[definition],'') <> [i].[definition] OR ISNULL([d].[function_type],'') <> [i].[function_type] OR ISNULL([d].[subtype],'') <> [i].[subtype] OR ISNULL([d].[dbms_last_modification_date],'') <> [i].[dbms_last_modification_date] ) BEGIN UPDATE [procedures_changes] SET [valid_to] = GETDATE() FROM [procedures_changes] [c] INNER JOIN [inserted] [u] ON [c].[procedure_id] = [u].[procedure_id] WHERE [valid_to] IS NULL; -- insert changes (before and after values) for procedure - when procedure was updated INSERT INTO [procedures_changes] ([database_id], [procedure_id], [schema], [name], [object_type], [definition], [function_type], [subtype], [before_object_type], [before_definition], [before_function_type], [before_subtype], [operation], [dbms_last_modification_date], [valid_from], [update_id] ) SELECT [i].[database_id], [i].[procedure_id], [i].[schema], [i].[name], [i].[object_type], [i].[definition], [i].[function_type], [i].[subtype], [d].[object_type], [d].[definition], [d].[function_type], [d].[subtype], 'UPDATED', [i].[dbms_last_modification_date], [cc].[valid_to], [i].[update_id] FROM [inserted] [i] INNER JOIN [deleted] [d] ON [i].[procedure_id] = [d].[procedure_id] OUTER APPLY ( SELECT MAX([valid_to]) AS [valid_to] FROM [procedures_changes] [c] WHERE [c].[procedure_id] = [d].[procedure_id] AND [c].[valid_to] IS NOT NULL ) [cc] WHERE [i].[status] = 'A' AND [d].[status] = 'A' AND (ISNULL([d].[schema],'') <> [i].[schema] OR ISNULL([d].[name],'') <> [i].[name] OR ISNULL([d].[object_type],'') <> [i].[object_type] OR ISNULL([d].[definition],'') <> [i].[definition] OR ISNULL([d].[function_type],'') <> [i].[function_type] OR ISNULL([d].[subtype],'') <> [i].[subtype]); END; BEGIN -- insert changes (deleted values) for procedure - when procedure was deleted INSERT INTO [procedures_changes] ([database_id], [procedure_id], [schema], [name], [object_type], [definition], [function_type], [subtype], [operation], [dbms_last_modification_date], [valid_to], [update_id] ) SELECT [d].[database_id], [d].[procedure_id], [d].[schema], [d].[name], [d].[object_type], [d].[definition], [d].[function_type], [d].[subtype], 'DELETED', [i].[dbms_last_modification_date], GETDATE(), [i].[update_id] FROM [inserted] [i] INNER JOIN [deleted] [d] ON [i].[procedure_id] = [d].[procedure_id] WHERE [i].[status] = 'D' AND [d].[status] = 'A'; --insert changes (updated values) for procedure - when procedure was restored INSERT INTO [procedures_changes] ([database_id], [procedure_id], [schema], [name], [object_type], [definition], [function_type], [subtype], [operation], [dbms_last_modification_date], [valid_from], [update_id] ) SELECT [i].[database_id], [i].[procedure_id], [i].[schema], [i].[name], [i].[object_type], [i].[definition], [i].[function_type], [i].[subtype], 'ADDED', [i].[dbms_last_modification_date], GETDATE(), [i].[update_id] FROM [inserted] [i] INNER JOIN [deleted] [d] ON [i].[procedure_id] = [d].[procedure_id] WHERE [i].[status] = 'A' AND [d].[status] = 'D'; END;
Schema change tracking trigger
-- ============================================= -- Description: Insert procedure's changes to schema change tracking tables -- ============================================= CREATE TRIGGER [trg_procedures_change_track_update] ON [procedures] FOR UPDATE AS -- skip manual objects created through Dataedo application IF EXISTS ( SELECT TOP (1) 1 FROM [INSERTED] WHERE [source] = 'USER' ) BEGIN RETURN; END; -- check if object property change IF EXISTS ( SELECT TOP (1) 1 FROM [inserted] [i] INNER JOIN [deleted] [d] ON [i].[procedure_id] = [d].[procedure_id] WHERE ISNULL([d].[schema],'') <> [i].[schema] OR ISNULL([d].[name],'') <> [i].[name] OR ISNULL([d].[object_type],'') <> [i].[object_type] OR ISNULL([d].[definition],'') <> [i].[definition] OR ISNULL([d].[function_type],'') <> [i].[function_type] OR ISNULL([d].[subtype],'') <> [i].[subtype] OR ISNULL([d].[dbms_last_modification_date],'') <> [i].[dbms_last_modification_date] ) BEGIN UPDATE [procedures_changes] SET [valid_to] = GETDATE() FROM [procedures_changes] [c] INNER JOIN [inserted] [u] ON [c].[procedure_id] = [u].[procedure_id] WHERE [valid_to] IS NULL; -- insert changes (before and after values) for procedure - when procedure was updated INSERT INTO [procedures_changes] ([database_id], [procedure_id], [schema], [name], [object_type], [definition], [function_type], [subtype], [before_object_type], [before_definition], [before_function_type], [before_subtype], [operation], [dbms_last_modification_date], [valid_from], [update_id] ) SELECT [i].[database_id], [i].[procedure_id], [i].[schema], [i].[name], [i].[object_type], [i].[definition], [i].[function_type], [i].[subtype], [d].[object_type], [d].[definition], [d].[function_type], [d].[subtype], 'UPDATED', [i].[dbms_last_modification_date], [cc].[valid_to], [i].[update_id] FROM [inserted] [i] INNER JOIN [deleted] [d] ON [i].[procedure_id] = [d].[procedure_id] OUTER APPLY ( SELECT MAX([valid_to]) AS [valid_to] FROM [procedures_changes] [c] WHERE [c].[procedure_id] = [d].[procedure_id] AND [c].[valid_to] IS NOT NULL ) [cc] WHERE [i].[status] = 'A' AND [d].[status] = 'A' AND (ISNULL([d].[schema],'') <> [i].[schema] OR ISNULL([d].[name],'') <> [i].[name] OR ISNULL([d].[object_type],'') <> [i].[object_type] OR ISNULL([d].[definition],'') <> [i].[definition] OR ISNULL([d].[function_type],'') <> [i].[function_type] OR ISNULL([d].[subtype],'') <> [i].[subtype]); END; BEGIN -- insert changes (deleted values) for procedure - when procedure was deleted INSERT INTO [procedures_changes] ([database_id], [procedure_id], [schema], [name], [object_type], [definition], [function_type], [subtype], [operation], [dbms_last_modification_date], [valid_to], [update_id] ) SELECT [d].[database_id], [d].[procedure_id], [d].[schema], [d].[name], [d].[object_type], [d].[definition], [d].[function_type], [d].[subtype], 'DELETED', [i].[dbms_last_modification_date], GETDATE(), [i].[update_id] FROM [inserted] [i] INNER JOIN [deleted] [d] ON [i].[procedure_id] = [d].[procedure_id] WHERE [i].[status] = 'D' AND [d].[status] = 'A'; --insert changes (updated values) for procedure - when procedure was restored INSERT INTO [procedures_changes] ([database_id], [procedure_id], [schema], [name], [object_type], [definition], [function_type], [subtype], [operation], [dbms_last_modification_date], [valid_from], [update_id] ) SELECT [i].[database_id], [i].[procedure_id], [i].[schema], [i].[name], [i].[object_type], [i].[definition], [i].[function_type], [i].[subtype], 'ADDED', [i].[dbms_last_modification_date], GETDATE(), [i].[update_id] FROM [inserted] [i] INNER JOIN [deleted] [d] ON [i].[procedure_id] = [d].[procedure_id] WHERE [i].[status] = 'A' AND [d].[status] = 'D'; END;
	trg_procedures_Modify	After Insert, Update	Standard insert/update trigger setting last_modification_date, modified by columns
-- ============================================= -- Author: Piotr Kononow -- Create date: 2014-06-18 -- Description: Updates last_modification_date, modified_by columns on insert or update -- ============================================= CREATE TRIGGER [trg_procedures_Modify] ON dbo.procedures AFTER INSERT, UPDATE AS BEGIN UPDATE [procedures] SET last_modification_date = GETDATE(), modified_by = suser_sname() WHERE procedure_id IN (SELECT DISTINCT procedure_id FROM Inserted) END
Standard insert/update trigger setting last_modification_date, modified by columns
-- ============================================= -- Author: Piotr Kononow -- Create date: 2014-06-18 -- Description: Updates last_modification_date, modified_by columns on insert or update -- ============================================= CREATE TRIGGER [trg_procedures_Modify] ON dbo.procedures AFTER INSERT, UPDATE AS BEGIN UPDATE [procedures] SET last_modification_date = GETDATE(), modified_by = suser_sname() WHERE procedure_id IN (SELECT DISTINCT procedure_id FROM Inserted) END

Uses

Name
dbo.procedures (Procedures and Functions)
dbo.databases (Documentations)
dbo.schema_updates (Imports/Updates)
dbo.trg_procedures_change_track_insert
dbo.procedures_changes
dbo.schema_updates (Imports/Updates)
dbo.trg_procedures_change_track_update
dbo.procedures_changes
dbo.trg_procedures_Modify
dbo.procedures (Procedures and Functions)

Used by

Name
dbo.procedures (Procedures and Functions)
dbo.trg_parameters_change_track_insert
dbo.trg_parameters_change_track_update
dbo.trg_procedures_Modify
dbo.parameters (Parameters)
dbo.parameters_changes
dbo.procedures_changes
dbo.procedures_modules (Procedures-modules)

Exported: 2018-12-06 15:15, Last imported: 2018-11-21 15:11