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

 

Impala

 

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