Regular expression to find all table names in a query

by

RegEx isn’t very good at this, as it’s a lot more complicated than it appears:

  • What if they use LEFT/RIGHT INNER/OUTER/CROSS/MERGE/NATURAL joins instead of the a,b syntax? The a,b syntax should be avoided anyway.
  • What about nested queries?
  • What if there is no table (selecting a constant)
  • What about line breaks and other whitespace formatting?
  • Alias names?

I could go on.

What you can do is look for an sql parser, and run your query through that.

More Related Contents:

  1. Matching numbers with regular expressions — only digits and commas
  2. store image in database or in a system file? [closed]
  3. Can I use a Regex in an XPath expression?
  4. Bulk Insert to Oracle using .NET
  5. RegEx: Smallest possible match or nongreedy match
  6. Parameterized Queries with LIKE and IN conditions
  7. Regex.IsMatch vs string.Contains
  8. Regular expression, split string by capital letter but ignore TLA
  9. Using “GO” within a transaction
  10. Make regular expression case insensitive in ASP.NET RegularExpressionValidator
  11. Is there a regex flavor that allows me to count the number of repetitions matched by the * and + operators?
  12. Does End Using close an open SQL Connection
  13. Does this code prevent SQL injection?
  14. How to Regex search/replace only first occurrence in a string in .NET?
  15. Sanitize table/column name in Dynamic SQL in .NET? (Prevent SQL injection attacks)
  16. How do I write LINQ’s .Skip(1000).Take(100) in pure SQL?
  17. Regex for string not containing multiple specific words
  18. How can you name the Dataset’s Tables you return in a stored proc?
  19. How can I create database tables from XSD files?
  20. Best HashTag Regex
  21. Regular expression for parsing links from a webpage?
  22. Why is some sql query much slower when used with SqlCommand?
  23. Regex replacement capture followed by digit
  24. Is it possible to send a collection of ID’s as a ADO.NET SQL parameter?
  25. How can I configure Entity Framework to automatically trim values retrieved for specific columns mapped to char(N) fields?
  26. How do I convert a string into safe SQL String?
  27. Regex to match anything but two words
  28. How to return a page of results from SQL?
  29. Using a variable for table name in ‘From’ clause in SQL Server 2008
  30. Regex for all PRINTABLE characters

Leave a Comment