Retrieve/Refactor table & column name

If you are looking to use a product to parse SQL statements in an attempt to achieve something listed below, then, this page is the right place for you.

1. Extract all tables and field name. (SQL sample), (Download C# demo, Java demo)

2. Parse the values and field names in where/having clause, or check that the user has specified specific columns in the where clause. ( SQL sample )

3. Know which tables will be accessed, and how these tables will be accessed (read, write or both) ( SQL sample )

4. Know which table and column was used in a select list field. ( SQL sample)

5. Rename specific table name and rebuild the SQL statement. ( SQL sample)

6. Column impact analysis, build source-to-target column/table mappings.

Our powerful SQL parser can process SQL dialects including Oracle, SQL Server/Sybase, DB2, MySQL, Microsoft Access and Teradata. PostgreSQL will be supported soon.

Still not find the solution you need? Please take a look here to find out more demos, or just send us an email and we'll get back to you within 24 hours.

In addition, here is a forum discussing the general SQL parser.

• Fetch columns and tables in SQL script (Java version)
• Fetch columns and tables in SQL script (.NET version)
• Rename table names in SQL script
• Find out what clause a DB Object belongs to?
• Get referenced table and columns in select list item (Java version).
• Column impact analysis