Interested to Buy Any Domain ? << Click Here >> for more details...
What is a temp table? how to denote temp table?
- 4 Answers
- 11770 Views
- Oracle, I also Faced
- E-Mail Answers
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
List some of the products of sybase.
How do you check database space? What measures are there to increase the db space?
What is replication server in sybase?
What is ceiling()?
Explain defncopy and it's usage?
State some of the products of sybase?
What are the advantages that you can get from mainframe connect in sybase?
What is sybase? What are its important features?
What do you mean by mainframe connect tool in sybase?
How do I force an index to be used in sybase?
What is open server in sybase?
How to save space when inserting rows monotonically?
How do I create a database in sybase central?
What do you mean by deferred update in sybase?
How to change varchar(m) to varchar(n) in sybase?
