Temporary tables and views are non-permanent tables/views that only exist for the duration of a database session. When a database session terminates, its temporary tables/views are automatically deleted. Temporary tables/views are only visible to the R:BASE session that creates them and remain invisible to other R:BASE users. Several users can create temporary tables/views with the same name, and each user will see only that particular version of the table/view.
Temporary tables and views may be stored in temporary files or in memory, where the created table/view usage determines which resource method provides the ideal application performance.
Creating Temporary Tables/Views
Advantages of Temporary Tables/Views
File-based Temporary Tables/Views
In-memory Temporary Tables/Views
Differentiate Table/View Types
How Tables and Views are Stored
When to Use What Table/View Type
Using Forms, Labels and Reports with Temporary Tables/Views
Removing Temporary Tables/Views
