24 Apr 2013

what are the different types of temporary tables in TD?


These are 3 tables
Derived temporary tables.   // query level only (query completed automatically erase data and dd)
Volatile temporary tables.  // session level and  and (logoff session and automatic erase the table and DD)
Global temporary tables.//sesson level (logoff session and automatic erase the table data, not delete the DD).

No comments:

Post a Comment