I'm looking at using temporary tables in place of in-memory tables for some parts of my app. I'm blocked because I use the presence of the table as a flag to say no one else should be doing this (eg moving records around for relationships in a treeview). With in-memory tables I can test for the existence of the table, but with temporary tables I can't.

Can we have an option that essentially does

select * from information.temporarytables SHOWALL

Roy Lambert

Roy,

<< I'm looking at using temporary tables in place of in-memory tables for
some parts of my app. I'm blocked because I use the presence of the table as
a flag to say no one else should be doing this (eg moving records around for
relationships in a treeview). With in-memory tables I can test for the
existence of the table, but with temporary tables I can't. >>

Are you looking for global (not per-session) temporary tables ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< I'm looking at using temporary tables in place of in-memory tables for
>some parts of my app. I'm blocked because I use the presence of the table as
>a flag to say no one else should be doing this (eg moving records around for
>relationships in a treeview). With in-memory tables I can test for the
>existence of the table, but with temporary tables I can't. >>
>
>Are you looking for global (not per-session) temporary tables ?

That would certainly be one way of doing it, but I was more just thinking of being able to query for all the temporary tables in use. Since I don't know how its working under the hood I have no idea if its even achievable. My assumption is that the config file is updated but you might be doing something totally different.

If its easily achievable great - I want it - if not I'll figure out an alternative.

Roy Lambert