Unique Temporary Table Names

To ensure that a temporary table name is unique for the current session, SAP ASE truncates the table name to 238 bytes, including the pound sign (#), if necessary and appends a 17-digit numeric suffix that is unique for each SAP ASE 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)