CREATE VOLATILE TABLE rgWork1 (
client INT NOT NULL,
) UNIQUE PRIMARY INDEX (client)
ON COMMIT PRESERVE ROWS;
DROP TABLE rgWork1;
The table is linked to the session, so you don't have to drop it if you're going to log out.
UNIQUE PRIMARY INDEX (...)or
PRIMARY INDEX (...)is optional. It works fine without it, but leaving it off can affect performance.
However, if you leave off
ON COMMIT PRESERVE ROWS, you can INSERT rows, but they won't be there when you SELECT from the table.