Mega Code Archive
Match a table name in tempdb INFORMATION_SCHEMA TABLES
<![CDATA[
5> SELECT TABLE_NAME FROM tempdb.INFORMATION_SCHEMA.TABLES
6> WHERE TABLE_NAME LIKE '%#%';
7> GO
TABLE_NAME
--------------------------------------------------------------------------------------------------------------------------------
#4460231C
#4C0144E4
#T42________________________________________________________________________________________________________________000000000019
#73DA2C14
#7F4BDEC0
1>
2>
]]>