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.

Supported Database


Google BigQuery


Couchbase database


IBM DB2 database


EMC Greenplum


SAP Hana


hadoop hive




IBM Informix database


MySQL database


Netezza database


Openedge database


Oracle database


PostgreSQL database


Amazon redshift


Snowflake SQL


Spark SQL


Microsoft SQL Server database


Sybase database


Teradata database


Vertica database


Microsfot Office Access database
Download General SQL Parser