In the T-SQL window I have created some temporary tables using the syntax

SELECT * INTO #MyTempTable FROM MyTable.

Where can I find what temporary tables are currently available (I don't want to delete them yet using DROP TABLE ...)? I cannot find them in any enterprise mgr. table listing. Is it stored in memory like a VFP temporary cursor? What is the scope of these 'tables'? Are they present until the SQL session finishes?

Any help would be appreciated.

Alan