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.

sstupdate
 employees(tetUpdate)
   department_name
   department_id
 sstselect
  deparments(tetSelect)
    department_name
    department_id

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.