There is another way to remove a volatile table?

Database

There is another way to remove a volatile table?

Hello,

I am connected in SQL Assistant, and run a SP who believes, this SP uses a volatile table. I need to know how to remove the TV from the SP. Without having to disconnect from the session.

If not possible, I could tell you that answer docume tion meeting in order to have a physical document with which to sustain him that answer to my boss

thanks

Tags (1)
4 REPLIES
Teradata Employee

Re: There is another way to remove a volatile table?

What do you mean my removing a VT from SP? As in VT stays created after SP is executed? Or you want to remove the usage of VT from SP?

Senior Supporter

Re: There is another way to remove a volatile table?

you can simply drop the VT table within the SP

Teradata Employee

Re: There is another way to remove a volatile table?

HELP VOLATILE TABLE;

Will list the Volatile Tables that exist for the current session.

You can simply DROP TableName; for any volatile table you want to remove prior to disconnecting the session.

For information on both these statements, see: SQL Reference - Data Definition Language - Syntax & Examples

Re: There is another way to remove a volatile table?

Thanks, for your help I see: SQL Reference - Data Definition Language - Syntax & Examples. Sorry for my english.