There are two ways to differentiate between real and temporary tables/views. One way is to view the Tables or Views areas within the Database Explorer. If defined, note that temporary tables and views will have a red icon next to the table/view name. A list of temporary tables/views may also be grouped by sorting the list by the "Date/Time" column in descending order, placing the newly created objects at the top of the display. The Data Dictionary will also show the temporary tables/views displayed with the red icon next to the name.
Another method to differentiate real and temporary tables/views, which also draws a distinction between file-based and in-memory temporary tables/views, is the LIST command. When the LIST results are written out, a "(T)" in front of the table name indicates the item is a temporary table/view. The LIST results will also indicate which item is an in-memory temporary table/view with an "(I)" in front of the name. The below LIST command results show the example temporary tables/views that may be created with the provided examples.
Name Columns Rows Comments
------------------- ------- --------- ------------------------------------
(T)tCustomer 17 30 Customer Information
(T)tInvoiceHeader 18 0 Invoice Header Information
(T)tInvoiceDetail 8 0 Invoice Header Information
(I)iTasks 12 0
(T)tiYTDInvoiceTotal 2 N/A
(I)tiCustomerContact 8 N/A
