VistaDB 5
Gibraltar VistaDB > Developer's Guide > SQL Reference > SQL Reference - Temp Tables
SQL Reference - Temp Tables

VistaDB supports temp tables through a syntax like SQL Server. Temp tables are stored on disk in a separate temp database that is deleted when the database connection is closed.

See the temp table example topic for more help.

Global Temp Tables do not exist, and cannot be created.

Table as a Variable

Tables as a variable for procedures are also supported. These are another form of temp table, but they only live for the life of the procedure calling them.

See the table variable example topic for more help.

This is often the way to get around the building an XML list dynamically need in older SQL code. You almost never have the need to do this now that tables are a type of variable.

See Also