Mega Code Archive

 

Categories / MSSQL Tutorial / System Settings

 

Query tempdb INFORMATION_SCHEMA TABLES

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>