IMPORTANT:
Commands with UPDATE, DELETE or DROP can ruin your data! Please use these queries with caution. We highly recommend that you backup your database before trying out these commands and to load them up first on a test server. Use at your own risk.

Associated SQL Command:
-- ************************************************************ -- ************* BACKUP YOU DATA FIRST ************ -- ************* BACKUP YOU DATA FIRST ************ -- ************* BACKUP YOU DATA FIRST ************ -- ************************************************************ DECLARE @COMPANY_ID AS VARCHAR(50), @DATABASE_NAME AS VARCHAR(50) SET @COMPANY_ID = 'YOUR COMPANY ID' SET @DATABASE_NAME = 'YOUR DB NAME' USE DYNAMICS GO SELECT * FROM SY01500 WHERE CMPANYID = @COMPANY_ID IF @@ROWCOUNT > 0 BEGIN DELETE MC60100 WHERE CMPANYID = @COMPANY_ID DELETE MC60200 WHERE CMPANYID = @COMPANY_ID DELETE SY00801 WHERE CMPANYID = @COMPANY_ID DELETE SY01500 WHERE CMPANYID = @COMPANY_ID DELETE SY01900 WHERE CMPANYID = @COMPANY_ID DELETE SY02000 WHERE CMPANYID = @COMPANY_ID DELETE SY02100 WHERE CMPANYID = @COMPANY_ID DELETE SY05200 WHERE CMPANYID = @COMPANY_ID DELETE SY40500 WHERE CMPANYID = @COMPANY_ID DELETE SY60100 WHERE CMPANYID = @COMPANY_ID DELETE UPR10300 WHERE CMPANYID = @COMPANY_ID DELETE UPR10304 WHERE CMPANYID = @COMPANY_ID DELETE W200002 WHERE CMPANYID = @COMPANY_ID DELETE DU000020 WHERE COMPANYID = @COMPANY_ID DELETE DU000030 WHERE COMPANYID = @COMPANY_ID DELETE DB_UPGRADE WHERE DB_NAME = @DATABASE_NAME DELETE SY40500 WHERE CMPANYID = @COMPANY_ID DELETE SY40502 WHERE BARULEID NOT IN (SELECT BARULEID FROM SY40500) DELETE SY40503 WHERE BARULEID NOT IN (SELECT BARULEID FROM SY40500) DELETE SY40504 WHERE BARULEID NOT IN (SELECT BARULEID FROM SY40500) DELETE SY40505 WHERE BARULEID NOT IN (SELECT BARULEID FROM SY40500) DELETE SY40506 WHERE BARULEID NOT IN (SELECT BARULEID FROM SY40500) END
Viewed: 16416 times

Submitted by: Victoria Hanson

View complete list

previous script

next script