public static string RetrieveSQLTableName(string statement)
{
var result = "";
if (statement.ToUpper().StartsWith("INSERT INTO"))
{
var rex = new Regex(@"(?i)(?<=\bINSERT INTO\s)[\p{L}_-]+");
result = rex.Match(statement).Value.ToLower();
}
else if (statement.ToUpper().StartsWith("UPDATE"))
{
var rex = new Regex(@"(?i)(?<=\bUPDATE\s)[\p{L}_-]+");
result = rex.Match(statement).Value.ToLower();
}
else if (statement.ToUpper().StartsWith("SELECT"))
{
var rex = new Regex(@"(?i)(?<=\bFROM\s)[\p{L}_-]+");
result = rex.Match(statement).Value.ToLower();
}
return result;
}