Storage of table variable

Table variables are stored in the tempdb database for execution scope only. 
Let us run this code


declare @t table(i int)
select * from tempdb.INFORMATION_SCHEMA.TABLES  

The result is


TABLE_CATALOG       TABLE_SCHEMA   TABLE_NAME       TABLE_TYPE
tempdb               dbo           #BAB3F665        BASE TABLE

If your server does not use any temporary tables, you will get the above result only. As you see a table variable is stored in the tempdb database for the execution scope only just like a temporary table. The name is prefixed by #. But unlike a temporary table, the name does not contain underscores. Becauase they are stored in execution scope only, you cannot query the INFORMATION_SCHEMA.TABLES alone to get the table variable information. The following code will not show you any table vaiables


select * from tempdb.INFORMATION_SCHEMA.TABLES