Deleting a document from SarFoi

Sometimes, users will upload the wrong document to SARFOI and then ask for it to be deleted.

You'll need to know the case number and the document to be deleted.

SQL Management Studio for this one.

Connect to QCHA-SQL1, Database is SARFOI

Select * from documents where caseID = 1184 (That's just an example case number)

Run that and you'll get the list of documents attached to that case

Identify which document to be removed. (In this example, let's use 3541)

DELETE from DOCUMENTS where DocID = 3541

BE REALLY CAREFUL and ideally have another set of eyes on this before you run it. Deletion in SQL is NON RECOVERABLE!!!!