SONAR数据库很少泄密，直接去研究了一下。经过一天反复实践，把重点的几个表来说明一下。

说明一下，SONAR提供删除项目的功能，但大量数据并没有删除掉。

 

select * from projects where scope='PRJ' AND qualifier='TRK' order by name;

delete  from resource_index where root_project_id in (37641,37902,38053,37456,38204,38355,38506);

delete from sonar.snapshot_sources where snapshot_id

in

(

select id from sonar.snapshots where root_project_id in (37641,37902,38053,37456,38204,38355)

);

delete from sonar.project_measures where snapshot_id

in

(select id from snapshots where root_project_id in (37641,37902,38053,37456,38204,38355));

delete from projects where root_id in (37641,37902,38053,37456,38204,38355);

delete from projects where id in (37641,37902,38053,37456,38204,38355);

delete from sonar.snapshots where root_project_id in (37641,37902,38053,37456,38204,38355);

delete from rule_failures

where snapshot_id not in

(

select id from snapshots );