using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text.RegularExpressions;
 
public class Test
{
	public static void Main()
	{
		var str = "The DELETE statement conflicted with the REFERENCE constraint \"FK_dbo.MyApprovals_dbo.My_ApproverMyId\". The conflict occurred in database \"DatabaseDev\", table \"dbo.DatabaseTable\", column 'ApproverPositionId'.\r\nThe statement has been terminated.";
		var m = Regex.Match(str, @"(?s)(?<delete>[A-Z]+)\s+statement.*?,\s+table\s+""\w+\.(?<table>[^""]+)");
        if (m.Success) {
        	Console.WriteLine(m.Groups["delete"].Value);
        	Console.WriteLine(m.Groups["table"].Value);
        }
	}
}

dXNpbmcgU3lzdGVtOwp1c2luZyBTeXN0ZW0uQ29sbGVjdGlvbnMuR2VuZXJpYzsKdXNpbmcgU3lzdGVtLklPOwp1c2luZyBTeXN0ZW0uTGlucTsKdXNpbmcgU3lzdGVtLlRleHQuUmVndWxhckV4cHJlc3Npb25zOwoKcHVibGljIGNsYXNzIFRlc3QKewoJcHVibGljIHN0YXRpYyB2b2lkIE1haW4oKQoJewoJCXZhciBzdHIgPSAiVGhlIERFTEVURSBzdGF0ZW1lbnQgY29uZmxpY3RlZCB3aXRoIHRoZSBSRUZFUkVOQ0UgY29uc3RyYWludCBcIkZLX2Riby5NeUFwcHJvdmFsc19kYm8uTXlfQXBwcm92ZXJNeUlkXCIuIFRoZSBjb25mbGljdCBvY2N1cnJlZCBpbiBkYXRhYmFzZSBcIkRhdGFiYXNlRGV2XCIsIHRhYmxlIFwiZGJvLkRhdGFiYXNlVGFibGVcIiwgY29sdW1uICdBcHByb3ZlclBvc2l0aW9uSWQnLlxyXG5UaGUgc3RhdGVtZW50IGhhcyBiZWVuIHRlcm1pbmF0ZWQuIjsKCQl2YXIgbSA9IFJlZ2V4Lk1hdGNoKHN0ciwgQCIoP3MpKD88ZGVsZXRlPltBLVpdKylccytzdGF0ZW1lbnQuKj8sXHMrdGFibGVccysiIlx3K1wuKD88dGFibGU+W14iIl0rKSIpOwogICAgICAgIGlmIChtLlN1Y2Nlc3MpIHsKICAgICAgICAJQ29uc29sZS5Xcml0ZUxpbmUobS5Hcm91cHNbImRlbGV0ZSJdLlZhbHVlKTsKICAgICAgICAJQ29uc29sZS5Xcml0ZUxpbmUobS5Hcm91cHNbInRhYmxlIl0uVmFsdWUpOwogICAgICAgIH0KCX0KfQ==