Chapter 8: Creating Databases and Tables

Ensuring that the temporary table name is unique

To ensure that a temporary table name is unique for the current session, Adaptive Server:

Truncates the table name to 238 bytes, including the pound sign (#)—if necessary
Appends a 17-digit numeric suffix that is unique for an Adaptive Server session

The following example shows a table created as #temptable and stored as #temptable00000050010721973:

use pubs2 
go 
create table #temptable (task char(30)) 
go 
use tempdb 
go 
select name from sysobjects where name like
    "#temptable%" 
go

name 
------------------------------ 
#temptable00000050010721973 
 
(1 row affected)