BCC Deleting Project

Here I have listed out SQL to delete

1) A particular project
2) All active projects
3) All projects

Deleting a particular project

-- Find the project
select * from EPUB_PROJECT  where display_name like '%Catalog Import%' and status=0;

--Delete asset from Lock table
delete from avm_asset_lock where workspace_id in (select id from avm_devline where name in
(select workspace from epub_project where project_id = 'prj154011'));

---- delete history of the project
delete from EPUB_PR_HISTORY where project_id in (select project_id from epub_project where project_id = 'prj154011');
--
---- delete the project
delete from epub_project where project_id = 'prj154011';
--
---- delete history of the process
delete from EPUB_PROC_HISTORY where process_id in (select process_id from epub_process where project = 'prj154011');
--
---- delete task information of process
delete from EPUB_PROC_TASKINFO where id in (select process_id from epub_process where project = 'prj154011');
--
---- delete states of project (if any)
delete  from EPUB_IND_WORKFLOW where process_id in (select process_id from epub_process where project = 'prj154011');
--
---- finally delete the process
delete from epub_process where  project = 'prj154011';

Deleting all active/open projects

delete from avm_asset_lock ;

delete from EPUB_PR_HISTORY where project_id in (select project_id from epub_project where status=0);

delete from EPUB_PROC_HISTORY where process_id in

(select process_id from epub_process where project in (select project_id from epub_project where status=0));

delete from EPUB_PROC_TASKINFO where id in

(select process_id from epub_process where project in (select project_id from epub_project where status=0));

delete from EPUB_WORKFLOW_STRS where id in

(select ID from EPUB_IND_WORKFLOW where process_id in

(select process_id from epub_process where project in (select project_id from epub_project where status=0)));

delete  from EPUB_IND_WORKFLOW where process_id in

(select process_id from epub_process where project in (select project_id from epub_project where status=0));

delete from epub_process where project in (select project_id from epub_project where status=0);

delete from epub_project where status=0;

Deleting all projects

delete from EPUB_PR_HISTORY;

delete from EPUB_PROC_HISTORY;

delete from EPUB_PROC_TASKINFO ;

delete from EPUB_WORKFLOW_STRS ;

delete  from EPUB_IND_WORKFLOW ;

delete from epub_process ;

delete from epub_project ;

delete from avm_asset_lock;