Volatile Tables - Current Display

Analytics

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
3 REPLIES
Junior Contributor

Re: Volatile Tables - Current Display

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

Dieter
Enthusiast

Re: Volatile Tables - Current Display

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

Re: Volatile Tables - Current Display

Shure ;-)

HELP VOLATILE TABLE;

Dieter