Capturing table name when parsing sql statement.

Lets say that I have an sql that look like this:

insert into test1 select * from test;
update test2 set col1 = 1;

I want to capture the name of the tables that are going to be modified (update, insert or delete) without executing the sql statement. So that I can make a copy of these tables before I execute the modifcations.

1. Is there a way to capture the names of these tables when the sql is parsed.
2. Can I parse the sql without executing it.

Thanks !!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 20 1999 - 13:29:12 CDT