Query tempdb.INFORMATION_SCHEMA.TABLES : Information_schema « System Settings « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Settings
3. Information_schema

6> DECLARE @T TABLE(col1 INT);
7> INSERT INTO @T VALUES(1);
8> SELECT TABLE_NAME FROM tempdb.INFORMATION_SCHEMA.TABLES
9> WHERE TABLE_NAME LIKE '%#%';
10> GO
TABLE_NAME
--------------------------------------------------------------------------------------------------------------------------------
#4460231C
#4C0144E4
#T42________________________________________________________________________________________________________________000000000019
#642DD430
#73DA2C14
#7F4BDEC0
1>
2>