What is a temp table? how to denote temp table?
Answer Posted / pavan
Hi, This answer is with respect Sybase ASE database
# temp-table
A temp table is created with a prefix of #. These are
session specific. That means if user-1 creates some temp
tables with #<some name> and logs out and then logs-in into
the database, he will not be able to see the #<table> which
he created.
Shareable temp-table
In turn, if the user creates tables in tempdb without
any "#" , then the table becomes shareable temp table.
These will remain in tempdb till the ASE is rebooted. If
the user logs-out and then logs-in , even in second
sessioin he can still access these table.
- Pavan
Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
Explain procedure cache?
What do you mean by asa in sybase?
What do you mean by adaptive server enterprise?
List the types of locking?
Explain update statistics.
Explain about the features of sybase iq?
Can I use a named pipe to bcp/dump data out or in in sybase?
What is the use of 'with check' option in views?
Can I run any transact-sql command on a partitioned table in sybase?
What is sybase used for?
What is sybase infomaker?
What is open client in sybase?
What causes re-resolution of a stored procedure in sybase?
What is the use of sp_helprotect in sybase?
How to implement if-then-else in a select clause in sybase?