public static string[] ExtractTablesFromSQL(string cmdString)
{
return Regex.Matches(cmdString, @"(?<=from|join)(\s+\w+\b)", RegexOptions.IgnoreCase)
.Cast<Match>()
.Select(m => m.Groups[0].Value.Trim())
.ToArray();
}
public static string[] ExtractTablesFromSQL(string cmdString)
{
return Regex.Matches(cmdString, @"(?<=from|join)(\s+\w+\b)", RegexOptions.IgnoreCase)
.Cast<Match>()
.Select(m => m.Groups[0].Value.Trim())
.ToArray();
}