Re: Undo after drop table...

And, as a point of order, a commit is irrelevant after a drop table.

Rollback and commit statements affect DML, not DDL.

It's a bit of a bugbear of mine; I get so many scripts from developers in the form:

CREATE TABLE <table_name> (
...
...

);

COMMIT; CREATE TABLE <table_name> (
...
...

);

COMMIT; etc. etc. It drives me mad! Received on Fri Nov 25 2005 - 08:28:23 CST