CREATE PROCEDURE [P_RemoveDataBaseTeste]
    @pCompanyDb nvarchar(128)
AS
BEGIN
    ---- Remove historico de documentos de Servico -------------
            DELETE
            FROM "DocHist"
            WHERE "BatchId" in
                (SELECT "BatchId"
                 FROM "Doc"
                 WHERE "EntityId" in
                     (SELECT "ID"
                      FROM "Entidade"
                      WHERE "CompanyDb" =@pCompanyDb) );
            DELETE
            FROM "Doc"
            WHERE "EntityId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
            DELETE
            FROM "SBO_TaxOne".."SettingEntityEnv"
            WHERE "EntityId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
            DELETE
            FROM "SBO_TaxOne".."SettingEntityEnvLog"
            WHERE "EntityId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
            DELETE
            FROM "SBO_TaxOne".."SettingEntitySeqCodeInv"
            WHERE "EntityId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
    ---- Remove historico de documentos Nf-e -------------------
            DELETE
            FROM "DBInvOne".."ProcessHist"
            WHERE "BatchId" in
                (SELECT "BatchId"
                 FROM "DBInvOne".."Process"
                 WHERE "CompanyId" in
                     (SELECT "ID"
                      FROM "Entidade"
                      WHERE "CompanyDb" =@pCompanyDb) );
            DELETE
            FROM "DBInvOne".."Process"
            WHERE "CompanyId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
            DELETE
            FROM "DBInvOne".."SettingCompany"
            WHERE "CompanyId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
            DELETE
            FROM "DBInvOne".."SettingCompanyLog"
            WHERE "CompanyId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
            DELETE
            FROM "DBInvOne".."SettingCompanySeqCode"
            WHERE "CompanyId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
    ---- Remove historico Df-e ----------------------------
            DELETE
            FROM "DBInvOne".."DocReceivedAttach"
            WHERE "DocReceivedId" in
                (SELECT "Id"
                 FROM "DBInvOne".."DocReceived"
                 WHERE "CompanyId" in
                     (SELECT "ID"
                      FROM "Entidade"
                      WHERE "CompanyDb" =@pCompanyDb) );
            DELETE
            FROM "DBInvOne".."DocReceivedAttach"
            WHERE "DocReceivedId" in
                (SELECT "Id"
                 FROM "DBInvOne".."DocReceived"
                 WHERE "CompanyId" in
                     (SELECT "ID"
                      FROM "Entidade"
                      WHERE "CompanyDb" =@pCompanyDb) );
            DELETE
            FROM "DBInvOne".."DocReceivedHist"
            WHERE "DocReceivedId" in
                (SELECT "Id"
                 FROM "DBInvOne".."DocReceived"
                 WHERE "CompanyId" in
                     (SELECT "ID"
                      FROM "Entidade"
                      WHERE "CompanyDb" =@pCompanyDb) );
            DELETE
            FROM "DBInvOne".."DocReceived"
            WHERE "CompanyId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
            DELETE
            FROM "DBInvOne".."ReceiptSetting"
            WHERE "EntityId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
            DELETE
            FROM "DBInvOne".."ReceiptSettingCfop"
            WHERE "EntityId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
            DELETE
            FROM "DBInvOne".."ReceiptSettingProductFoundBy"
            WHERE "EntityId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
            DELETE
            FROM "DBInvOne".."ReceiptSettingUsage"
            WHERE "EntityId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
            DELETE
            FROM "DBInvOne".."ReceiptSettingUserField"
            WHERE "EntityId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
   ---- Remover a apuracao ------------------------------------------
            DELETE
            FROM "SBO_TaxOne".."ApuracaoPeriodoDetalhe"
            WHERE "PeriodoApuracaoId" in
                (SELECT "ID"
                 FROM "SBO_TaxOne".."ApuracaoPeriodo"
                 WHERE "Entidade" in
                     (SELECT "ID"
                      FROM "Entidade"
                      WHERE "CompanyDb" =@pCompanyDb) );
            DELETE
            FROM "SBO_TaxOne".."ApuracaoPeriodoResumo"
            WHERE "PeriodoApuracao" in
                (SELECT "ID"
                 FROM "SBO_TaxOne".."ApuracaoPeriodo"
                 WHERE "Entidade" in
                     (SELECT "ID"
                      FROM "Entidade"
                      WHERE "CompanyDb" =@pCompanyDb) );
            DELETE
            FROM "SBO_TaxOne".."ApuracaoPeriodo"
            WHERE "Entidade" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
            DELETE
            FROM "SBO_TaxOne".."SpedFiscalSetting"
            WHERE "EntidadeId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
   --- Remove ECF --- TaxPlus
     
            DELETE
            FROM "SBO_TaxOne".."TX_ECF_PLANO_DE_CONTA_VINCULO"
            WHERE "CodigoDaVigencia" IN
                (SELECT "Codigo"
                 FROM "SBO_TaxOne".."TX_ECF_PLANO_DE_CONTA_VIGENCIA"
                 WHERE "CodigoDaEntidade" IN
                     (SELECT "ID"
                      FROM "Entidade"
                      WHERE "CompanyDb" =@pCompanyDb));
                      
            DELETE
            FROM "SBO_TaxOne".."TX_ECF_PLANO_DE_CONTA_VIGENCIA"
            WHERE "CodigoDaEntidade" IN
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
   --- Remove Entidade --- TaxPlus
            DELETE
            FROM "SBO_TaxOne".."EntidadeCategoriaImposto"
            WHERE "EntidadeId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
            DELETE
            FROM "SBO_TaxOne".."EntidadeCertificado"
            WHERE "EntidadeId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
            DELETE
            FROM "SBO_TaxOne".."EntidadeCertificadoLog"
            WHERE "EntidadeId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
            DELETE
            FROM "SBO_TaxOne".."EntidadeComplementoImposto"
            WHERE "EntidadeId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
            DELETE
            FROM "SBO_TaxOne".."EntidadeResponsavel"
            WHERE "Entidade" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
            DELETE
            FROM "SBO_TaxOne".."EntidadeSubstitutoTributario"
            WHERE "Entidade" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =@pCompanyDb);
END