37 lines
1.4 KiB
SQL
37 lines
1.4 KiB
SQL
Delete from PDFs
|
|
Delete from Versions
|
|
Delete from DocumentAudits
|
|
delete from Figures where ROFSTID not in(select rofstid from Associations)
|
|
Delete from ROFSTs where ROFSTID not in(select rofstid from Associations)
|
|
delete from roimages where rodbid not in(select rodbid from rofsts)
|
|
delete from documents where docid not in(select docid from entries)
|
|
PRINT 'Phase 1'
|
|
delete from tblAnnotations where deletestatus != 0
|
|
delete from drousages where docid in(select docid from tbldocuments where deletestatus != 0)
|
|
delete from tblEntries where deletestatus != 0
|
|
delete from tblDocuments where deletestatus != 0
|
|
delete from tblGrids where deletestatus != 0
|
|
delete from tblImages where deletestatus != 0
|
|
PRINT 'Phase 2'
|
|
delete from tblROUsages where deletestatus != 0
|
|
delete from tblTransitions where deletestatus != 0
|
|
delete from tblParts where deletestatus != 0
|
|
delete from tblItems where deletestatus != 0
|
|
and ItemID Not IN (Select ItemID from Parts)
|
|
PRINT 'Purge Contents'
|
|
delete from tblContents where deletestatus != 0
|
|
--and ContentID Not IN(Select ContentID from Parts)
|
|
--and ContentID Not IN(Select ContentID from Items)
|
|
PRINT 'Phase 3'
|
|
delete from AnnotationAudits
|
|
delete from ContentAudits
|
|
delete from EntryAudits
|
|
delete from DocumentAudits
|
|
delete from GridAudits
|
|
delete from ImageAudits
|
|
PRINT 'Phase 4'
|
|
delete from ItemAudits
|
|
delete from PartAudits
|
|
delete from ROUsageAudits
|
|
delete from TransitionAudits
|