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.