Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Reference Index > Temporary Tables and Views

Notes

Scroll Prev Top Next More

 

In regards to temporary tables in the database, always DISCONNECT and then CONNECT before using the AUTOCHK, PACK, or RELOAD commands.

 

Temporary tables/views are support in read-only structure (STATICDB is ON) environments.

 

When creating a temporary table/view, the following temporary system tables are also created:

 

oSYSTMP_COMMENTS

oSYSTMP_CONSTRAINTS

oSYSTMP_DEFAULTS

oSYSTMP_RULES

oSYSTMP_SERVERS

oSYSTMP_TRIGGERS

oSYSTMP_VIEWS

 

Temporary tables/views were first introduced in R:BASE 6.1 (July 1997).