Match a table name in 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

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>