Sybase Temporary Tables

Adaptive Server Enterprise/11.9.2.6/1290/P/EBF 10491 ESD1/Sun_svr4/OS 5.5.1/FBO/Mon Jul 15 06:54:22 2002

Session	DDL	Table Name Created (In tempdb)
1	create table #abcdefghijklmnopqr ( x int )	Created #abcdefghijkl00000200012536973
1	create table #a ( x int )	Created #a___________00000200012536973
1	create table #abced ( x int )	Created #abced_______00000200012536973
2	create table #abced ( x int )	Created #abced_______00000110012830476

Note: Session 1 shows the Session Id being re-used within the same session, but differing from Session 2.

#abcdefghijkl00000200012536973
#<----------><--------------->
1     12           17         


#<12 User Characters><17 Digit Sybase Generated Unique Session Number>

Roger Hall
COMPUSPEC