|
|
Posted by David Portas on 05/21/06 14:55
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/ms130214(en-US,SQL.90).aspx
--
Navigation:
[Reply to this message]
|