sys.tables starting with #

[Mark]

Hello,

if there are tables with names starting with a # I can´t look into them,
e.g. by doing "select * from tempdb.sys.tables". What is the reason for such
tables, who creates them and how I can see their content?

thanks and regards
Mark

[David Portas]

Mark wrote:

Hello,

if there are tables with names starting with a # I can´t look into them,
e.g. by doing "select * from tempdb.sys.tables". What is the reason for such
tables, who creates them and how I can see their content?

thanks and regards
Mark

Table names beginning with # are temp tables. They can be created like
any other but they reside in tempdb rather than the current database.
Try:

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

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/m...S,SQL.90).aspx
--