Jump to content

Creating Temp Tables

Christopher Ballenger

Recommended Posts

  • 4 weeks later...

Hi Chris,


Just like physical tables, you can either specify columns or use CREATE TABLE AS SELECT...

Here is the syntax:


CREATE[LOCAL]{TEMP | TEMPORARY} TABLE table-name{table-element-commalist}[ ON COMMIT {PRESERVE | DELETE} ROWS]






NOTE, this works only in 7.0.4 and above.


Regards, Jason

Link to comment
Share on other sites

  • 1 month later...
  • 1 year later...

I don't think you can do this in an SQL Script, but rather, against a published database from an external db application.


Jason can correct me if I'm wrong.


Given the age of this post, if you need more help, it might be better to raise a new question.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...