How to Create Volatile Table in Teradata?
When we say about the Volatile tables these are the simple tables but the only difference is that, they are volatile in nature.
Like a simple table, volatile table are also formed by the user and can only be used until the user is logged in. Once the user is logoff or disconnects, here Teradata manager will automatically drops the table from the session.
And once the table is dropped by Teradata manager, the data and definition inserted in the volatile table will be erased automatically. | |