Temp-tables compared to database tables
- Last Updated: March 30, 2020
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
A temp-table allows you to define a table that is not
part of any persistent database. You can use temp-tables within
a session or pass them between sessions. Temp-tables provide in-memory
buffering of data and transparent overflow to a temporary database
on disk when necessary. You can define a temp-table as being LIKE a
database table, and you can add fields of any type to this definition,
or you can define the table as a set of fields independent of any
particular database table. You can create, read, update, and delete
records in the temp-table much as you can with records in a database
table. You can define indexes to manage large sets of data efficiently. You
can access the records in the table with FIND and FOR EACH logic
or with queries.