All Forums Analytics
Craigrut 1 post Joined 10/07
25 Oct 2007
Volatile Tables - Current Display

Hi there,I am just working with several volatile tables and was curious if there was a way to display which tables I currently have already created, as well as what columns are them. Basically, just kind of like a snapshot of the current volatiles I have available so I don't keep getting the 'table already created' when I go to execute my code.Thank you for any help :)-Craig

dnoeth 4628 posts Joined 11/04
25 Oct 2007

Hi Craig,HELP VOLATILE TABLE list all VT within your session, for column definitions use HELP TABLE vt_tabke_nameDieter

Dieter

nithyanandam 65 posts Joined 10/04
01 Nov 2007

I'm not clear on the first part of the command. Can you re-post it?

dnoeth 4628 posts Joined 11/04
02 Nov 2007

Shure ;-)HELP VOLATILE TABLE;Dieter

Dieter

You must sign in to leave a comment.