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