Hey all,
I'm wondering if there is anything technical preventing someone from making:
DROP TEMP TABLE tablename;
work. Implementation wise the command would fail if a temporary table of the given name doesn't exist. Today, if a temporary table exists it will be dropped, but if tablename is not schema-qualified and a table with the same names exists in the search path it would be dropped.
Plus its symmetrical with CREATE [TEMP] TABLE.
David J.