Buscar tabela Temporária

Fernanda,

Parece que existem cinco formas de fazer isto, veja qual você gosta mais:

==========================================================

5 Ways to List Temporary Tables using T-SQL

• Opção 1 – sys.tables

SELECT name
FROM tempdb.sys.tables
WHERE name LIKE '#%';

• Opção 2 – sys.objects

SELECT name 
FROM tempdb.sys.objects
WHERE type = 'U';

• Opção 3 – INFORMATION_SCHEMA.TABLES

SELECT TABLE_NAME
FROM TempDB.INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'Base Table';

• Opção 4 – sp_tables

USE tempdb;

EXEC sp_tables '#%';

OU

USE tempdb;

EXEC sp_tables 
  @table_name = '#%',
  @table_owner = 'dbo',
  @table_qualifier = 'tempdb',
  @table_type = "'TABLE'",
  @fUsePattern = 1;

• Opção 5 – dbo.sysobjects

SELECT name
FROM tempdb..sysobjects
WHERE name LIKE '#%';

OU

SELECT name
FROM tempdb.dbo.sysobjects
WHERE name LIKE '#%';

https://database.guide/5-ways-to-list-temporary-tables-using-t-sql/

==========================================================

[]'s,

Fabio I.

Obrigada!!

Obrigado por me pontuar.