What I want to accomplish is following:

For example in Oracle when we create temporary tables we have an option like this:

CREATE GLOBAL TEMPORARY TABLE

...............

ON COMMIT DELETE ROWS

OR

ON...