Для всех групп:
DELETE FROM MAXIMO.LAYOUT WHERE SCCONFIGID IN ((SELECT MAXIMO.SCCONFIG.SCCONFIGID FROM MAXIMO.SCCONFIG));
DELETE FROM MAXIMO.SCCONFIG;
DELETE FROM MAXIMO.SCCONFIG;
или для конкретной группы:
DELETE FROM LAYOUT WHERE SCCONFIGID IN (SELECT SCCONFIGID FROM SCCONFIG WHERE GROUPNAME = 'SECURITYGROUPNAME');
DELETE FROM SCCONFIG WHERE GROUPNAME = 'SECURITYGROUPNAME';
DELETE FROM SCCONFIG WHERE GROUPNAME = 'SECURITYGROUPNAME';
No comments:
Post a Comment