|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/25/2007 12:36:20 PM
Posts: 1,
Visits: 2
|
|
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
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 10/3/2008 7:39:41 AM
Posts: 483,
Visits: 213
|
|
Hi Craig,
HELP VOLATILE TABLE list all VT within your session, for column definitions use HELP TABLE vt_tabke_name
Dieter
|
|
|
|
|
Forum Guru
Group: Forum Members
Last Login: 3/5/2008 9:54:38 AM
Posts: 67,
Visits: 147
|
|
|
I'm not clear on the first part of the command. Can you re-post it?
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 10/3/2008 7:39:41 AM
Posts: 483,
Visits: 213
|
|
Shure ;-)
HELP VOLATILE TABLE;
Dieter
|
|
|
|