Remove a Pre-Installed Language

SQL Script

• Locate the variable @LanguageId in the script below and set the value to the Id of the language that has to be removed.The language id's can be found in the Languages table in the Sana Commerce database. This script can also be downloaded as a sql file.
• Execute the SQL script on the Sana Commerce database to remove the specified language.
  
  CREATE FUNCTION remfld19823
  (
  @xml XML,
  @field nvarchar(50)
  )
  RETURNS nvarchar(MAX)
  AS
  BEGIN
  DECLARE @value nvarchar(MAX);
  SELECT @value = N'<FieldsDictionary>'+CONVERT(nvarchar(max),@xml.query('for $v in /FieldsDictionary/*[@name != sql:variable("@field")]return $v'))+N'</FieldsDictionary>';
  RETURN @value;
  END
  GO
  BEGIN TRANSACTION
  BEGIN TRY
  DECLARE @languageId int;
  SET @languageId = 2070;
  IF ((SELECT count(id) FROM Websites WHERE DefaultLanguageId = @languageId) > 0)
  BEGIN
  raiserror('ERROR: language %d is used as default for website!', 11, 1, @languageId)
  END
  --Delete ProductEnrichments
  DELETE FROM ProductEnrichments
  WHERE LanguageId = @languageId;
  --Delete ChannelReferences
  DELETE FROM ChannelReferences
  WHERE (WebsiteLanguageId IN (SELECT Id
  FROM WebsiteLanguages
  WHERE LanguageId = @languageId))
  --Delete WebsiteLanguages
  DELETE FROM WebsiteLanguages
  WHERE LanguageId = @languageId
  --Delete SanaText
  DELETE FROM SanaText
  WHERE ((SELECT count(*) FROM ChannelReferences WHERE ChannelReferences.ItemId = SanaText.Id) = 0)
  --Delete ShopHomepages
  DELETE FROM ShopHomepages
  WHERE ((SELECT count(*) FROM ChannelReferences WHERE ChannelReferences.ItemId = ShopHomepages.Id) = 0)
  --Delete NewsItems
  DELETE FROM NewsItems
  WHERE ((SELECT count(*) FROM ChannelReferences WHERE ChannelReferences.ItemId = NewsItems.Id) = 0)
  --Delete ContentPages
  DELETE FROM ContentPages
  WHERE ((SELECT count(*) FROM ChannelReferences WHERE ChannelReferences.ItemId = ContentPages.Id) = 0)
  --Delete MailTemplates
  IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' and [name] = 'MailTemplate')
  DELETE FROM MailTemplate
  WHERE ((SELECT count(*) FROM ChannelReferences WHERE ChannelReferences.ItemId = MailTemplate.Id) = 0)
  --Delete PaymentMethodTranslation
  DELETE FROM PaymentMethodTranslation
  WHERE LanguageId = @languageId
  --Delete ProductCategoryTranslation
  IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' and [name] = 'ProductCategoryTranslation')
  DELETE FROM ProductCategoryTranslation
  WHERE LanguageId = @languageId
  --Delete ProductTranslation
  IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' and [name] = 'ProductTranslation')
  DELETE FROM ProductTranslation
  WHERE LanguageId = @languageId
  --Delete VariantComponentGroupTranslation
  IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' and [name] = 'VariantComponentGroupTranslation')
  DELETE FROM VariantComponentGroupTranslation
  WHERE LanguageId = @languageId
  --Delete VariantComponentTranslation
  IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' and [name] = 'VariantComponentTranslation')
  DELETE FROM VariantComponentTranslation
  WHERE LanguageId = @languageId
  --Delete Translations
  IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' and [name] = 'Translations')
  DELETE FROM Translations
  WHERE LanguageId = @languageId
  --Delete LanguagePreference from ShopAccount
  IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' and [name] = 'ShopAccount')
  UPDATE dbo.ShopAccount SET Fields = dbo.remfld19823(Fields,'LanguagePreference')
  WHERE CAST( Fields
  .query('
  for $descr in /FieldsDictionary/*[@name = "LanguagePreference"]
  return string($descr)
  ')
  .value('/', 'nvarchar(max)') AS xml)
  .value('/', 'nvarchar(max)') = @languageId
  --Delete Languages
  DELETE FROM Languages
  WHERE Id = @languageId;
  END TRY
  BEGIN CATCH
  PRINT ERROR_MESSAGE() + ' Transaction rolled back.'
  IF @@TRANCOUNT > 0
  ROLLBACK TRANSACTION
  END CATCH
  GO
  IF @@TRANCOUNT > 0
  COMMIT TRANSACTION
  GO
  IF EXISTS (
  SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES
  WHERE ROUTINE_NAME = 'remfld19823'
  AND ROUTINE_TYPE = 'FUNCTION'
  )
  DROP FUNCTION remfld19823
  GO