Deleting a section
Glossary Item Box
Introduction
NOTE
If a section was created based on the object that must be deleted, this section must be deleted first.
To delete a custom section in Creatio, you need access to the system configuration tools and its database.
ATTENTION
Before you delete a custom section, unlock the corresponding section in the SVN storage.
First, delete the database records. Use the following script to delete a section:
DECLARE @UId UNIQUEIDENTIFIER DECLARE @ModuleEntityUID UNIQUEIDENTIFIER; DECLARE @ModuleID UNIQUEIDENTIFIER; DECLARE @Name NVARCHAR(max) = 'ToDelete'; select @UId = UId from SysSchema where Name Like @Name select @ModuleEntityUID = Id from SysModuleEntity where SysEntitySchemaUId = @UId select @ModuleID = Id from SysModule where SysModuleEntityId = @ModuleEntityUID; delete from SysModuleInWorkplace where SysModuleId = @ModuleID; delete from SysModule where Id = @ModuleID; delete from SysModuleEdit where SysModuleEntityId = @ModuleEntityUID; delete from SysModuleEntity where Id = @ModuleEntityUID; delete from SysDetail where EntitySchemaUId = @UId; delete from SysLookup where SysEntitySchemaUId = @UId; delete from [Lookup] where SysEntitySchemaUId = @UId;
Please note that the “ToDelete” value must be replaced with the custom section schema name. After deleting database records, delete section custom schemas in the [Configuration] section (located under [Advanced settings]) in the following order:
- ToDeleteFile
- ToDeleteInFolder
- ToDeleteInTag
- ToDeleteTag
- ToDeleteFolder
- ToDelete
