Aquests comandaments SQL esborren les taules de historic de canvis de interlocutors comercials, articles i documents:

PRINT 'ACRD ...';
DELETE FROM ACRD;
GO
PRINT 'ACR1 ...';
DELETE FROM ACR1;
GO
PRINT 'ACR2 ...';
DELETE FROM ACR2;
GO
PRINT 'ACR3 ...';
DELETE FROM ACR3;
GO
PRINT 'ACR4 ...';
DELETE FROM ACR4;
GO
PRINT 'ACR5 ...';
DELETE FROM ACR5;
GO
PRINT 'ACR7 ...';
DELETE FROM ACR7;
GO

PRINT 'ACPR ...';
DELETE FROM ACPR;
GO

PRINT 'ACRB ...';
DELETE FROM ACRB;
GO

PRINT 'AITM ...';
DELETE FROM AITM;
GO
PRINT 'AIT1 ...';
DELETE FROM AIT1;
GO
PRINT 'AIT2 ...';
DELETE FROM AIT2;
GO
PRINT 'AIT3 ...';
DELETE FROM AIT3;
GO
PRINT 'AIT5 ...';
DELETE FROM AIT5;
GO
PRINT 'AIT7 ...';
DELETE FROM AIT7;
GO
PRINT 'AIT8 ...';
DELETE FROM AIT8;
GO
PRINT 'AIT9 ...';
DELETE FROM AIT9;
GO
PRINT 'AIT11 ...';
DELETE FROM AIT11;
GO
PRINT 'AIT13 ...';
DELETE FROM AIT13;
GO

PRINT 'AITW ...';
--DELETE FROM AITW;
SELECT 'Esborrant AITW ...' 
WHILE @@ROWCOUNT <> 0
  DELETE TOP (100000) AITW
GO

PRINT 'ADOC ...';
DELETE FROM ADOC;
GO
PRINT 'ADO1 ...';
DELETE FROM ADO1;
GO
PRINT 'ADO2 ...';
DELETE FROM ADO2;
GO
PRINT 'ADO3 ...';
DELETE FROM ADO3;
GO
PRINT 'ADO4 ...';
DELETE FROM ADO4;
GO
PRINT 'ADO5 ...';
DELETE FROM ADO5;
GO
PRINT 'ADO6 ...';
DELETE FROM ADO6;
GO
PRINT 'ADO7 ...';
DELETE FROM ADO7;
GO
PRINT 'ADO8 ...';
DELETE FROM ADO8;
GO
PRINT 'ADO9 ...';
DELETE FROM ADO9;
GO
PRINT 'ADO10 ...';
DELETE FROM ADO10;
GO
PRINT 'ADO11 ...';
DELETE FROM ADO11;
GO
PRINT 'ADO12 ...';
DELETE FROM ADO12;
GO
PRINT 'ADO13 ...';
DELETE FROM ADO13;
GO
PRINT 'ADO14 ...';
DELETE FROM ADO14;
GO
PRINT 'ADO15 ...';
DELETE FROM ADO15;
GO
PRINT 'ADO16 ...';
DELETE FROM ADO16;
GO
PRINT 'ADO17 ...';
DELETE FROM ADO17;
GO
PRINT 'ADO18 ...';
DELETE FROM ADO18;
GO
PRINT 'ADO19 ...';
DELETE FROM ADO19;
GO
PRINT 'ADO20 ...';
DELETE FROM ADO20;
GO
PRINT 'ADO21 ...';
DELETE FROM ADO21;
GO
PRINT 'ADO22 ...';
DELETE FROM ADO22;
GO
PRINT 'ADO23 ...';
DELETE FROM ADO23;
GO
PRINT 'ADO24 ...';
DELETE FROM ADO24;
GO
image_pdf