Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Does MaxDB supports temporary tables

By definition "A TEMPORARY table is visible only to the current connection, and is dropped automatically when the connection is closed.This means that two different connections can use the same temporary table name without conflicting with each other or with an existing non-TEMPORARY table of the same name."

This is what is mentioned about temporary tables in MySQL 5.0 Ref Manual.

Now the question is, does MaxDB supports creation of these kind of tables ? If yes what's the syntax?

Regards

Raja

replied

Hi,

just do

CREATE TABLE TEMP.<tablename> ...

Elke

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question