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






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>








26.14.Information_schema
26.14.1.select top 10 * from Information_schema.columns
26.14.2.Information_schema.views
26.14.3.Information_schema.tables
26.14.4.System views INFORMATION_SCHEMA
26.14.5.obtain metadata about database objects.
26.14.6.SELECT TABLE_CATALOG FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TestTable'
26.14.7.Match a table name in tempdb.INFORMATION_SCHEMA.TABLES
26.14.8.Query tempdb.INFORMATION_SCHEMA.TABLES
26.14.9.A script that creates a summary of the tables in a database
26.14.10.Check the view existance