Table column affected

If you are here to find how to get all tables and associated columns that are being used in SQL query, stored procedure and triggers. Then, this is the right place for you.

We provide tool that help you to fetch all involved tables and columns in thousands of SQL scripts precisely and quickly. You can also find out how tables were affected such as delete, insert, update and select in those scripts.

Take this SQL for example:

update employees e
set department_name =
(select department_name from deparments d
where e.department_id = d.department_id);

Table employees is marked as "updated" with associated columns, while table deparments is marked as "selected" with related columns.


Supported by the powerful parsing ability of General SQL Parser, this table and column affected tool had been successfully run against more than one million SQL scripts in the past 5 years.

Live Demo

Try our live demo with your own SQL script to get desired result instantly.

Download this tool

Please download the latest version of General SQL Parser from download page.

For Java version, please check under demos\gettablecolumns\ directory.

For .NET version, please check getTableColumn.cs under demoCollections\getTableColumn\ directory.

Other useful tools

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