All Forums Database
egmarrugo 2 posts Joined 01/13
23 Apr 2013
There is another way to remove a volatile table?



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



Adeel Chaudhry 773 posts Joined 04/08
24 Apr 2013

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?

-- If you are stuck at something .... consider it an opportunity to think anew.

ulrich 816 posts Joined 09/09
24 Apr 2013

you can simply drop the VT table within the SP

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

Fred 1096 posts Joined 08/04
24 Apr 2013

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

egmarrugo 2 posts Joined 01/13
25 Apr 2013

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

You must sign in to leave a comment.