DELETE FROM "SLSTANDARDSSTARTUP" WHERE 
  (StandardName = 'CDWA' or StandardName = 'ObjectID' or StandardName = 'DublinCore' or 
   StandardName = 'USMARC' or StandardName = 'Visual Resource Association v3.0' or StandardName = 'CIMI');

DELETE FROM "SLSTANDARDSLOOKUP" WHERE 
  (StandardName = 'CDWA' or StandardName = 'ObjectID' or StandardName = 'DublinCore' or 
   StandardName = 'USMARC' or StandardName = 'Visual Resource Association v3.0' or StandardName = 'CIMI');

DELETE FROM "SLSTANDARDFIELDS" WHERE 
  (StandardName = 'CDWA' or StandardName = 'ObjectID' or StandardName = 'DublinCore' or 
   StandardName = 'USMARC' or StandardName = 'Visual Resource Association v3.0' or StandardName = 'CIMI');


DELETE FROM "SLFIELDSTANDARDRELATION" WHERE 
  (StandardName = 'CDWA' or StandardName = 'ObjectID' or StandardName = 'DublinCore' or 
   StandardName = 'USMARC' or StandardName = 'Visual Resource Association v3.0' or StandardName = 'CIMI');
   
   
UPDATE SLSTANDARDSSTARTUP SET STANDARDID=1000 WHERE STANDARDID=0;
UPDATE SLSTANDARDSSTARTUP SET STANDARDID=1001 WHERE STANDARDID=1;
UPDATE SLSTANDARDSSTARTUP SET STANDARDID=1002 WHERE STANDARDID=2;
UPDATE SLSTANDARDSSTARTUP SET STANDARDID=1003 WHERE STANDARDID=3;
UPDATE SLSTANDARDSSTARTUP SET STANDARDID=1004 WHERE STANDARDID=4;
UPDATE SLSTANDARDSSTARTUP SET STANDARDID=1005 WHERE STANDARDID=5;

UPDATE SLStandardsLookup SET STANDARDID=1000 WHERE STANDARDID=0;
UPDATE SLStandardsLookup SET STANDARDID=1001 WHERE STANDARDID=1;
UPDATE SLStandardsLookup SET STANDARDID=1002 WHERE STANDARDID=2;
UPDATE SLStandardsLookup SET STANDARDID=1003 WHERE STANDARDID=3;
UPDATE SLStandardsLookup SET STANDARDID=1004 WHERE STANDARDID=4;
UPDATE SLStandardsLookup SET STANDARDID=1005 WHERE STANDARDID=5;

UPDATE SLStandardFields SET STANDARDID=1000 WHERE STANDARDID=0;
UPDATE SLStandardFields SET STANDARDID=1001 WHERE STANDARDID=1;
UPDATE SLStandardFields SET STANDARDID=1002 WHERE STANDARDID=2;
UPDATE SLStandardFields SET STANDARDID=1003 WHERE STANDARDID=3;
UPDATE SLStandardFields SET STANDARDID=1004 WHERE STANDARDID=4;
UPDATE SLStandardFields SET STANDARDID=1005 WHERE STANDARDID=5;

UPDATE SLFieldStandardRelation SET STANDARDID=1000 WHERE STANDARDID=0;
UPDATE SLFieldStandardRelation SET STANDARDID=1001 WHERE STANDARDID=1;
UPDATE SLFieldStandardRelation SET STANDARDID=1002 WHERE STANDARDID=2;
UPDATE SLFieldStandardRelation SET STANDARDID=1003 WHERE STANDARDID=3;
UPDATE SLFieldStandardRelation SET STANDARDID=1004 WHERE STANDARDID=4;
UPDATE SLFieldStandardRelation SET STANDARDID=1005 WHERE STANDARDID=5;
