Deletar registros da base BD SSM ADM

De GeoSales
Ir para navegação Ir para pesquisar
  • Deletes necessários para limpar as bases
Na base ADM:
select * from empresa order by nm_empresa asc
DELETE FROM EMPRESA_SYNC_BD
WHERE CD_EMPRESA IN 
(1129)

DELETE FROM EMPRESA_BD
WHERE CD_EMPRESA IN 
(1129)

DELETE FROM EMPRESA_SYNC_SISTEMA
WHERE CD_EMPRESA IN 
(1129)

DELETE FROM EMPRESA_SISTEMA
WHERE CD_EMPRESA IN 
(1129)

DELETE FROM EMPRESA
WHERE CD_EMPRESA IN 
(1129)