What is a temp table? how to denote temp table?
Answer Posted / jayakumar
Temporary tables are created in the tempdb database. To
create a temporary table, you must have created table
permission in tempdb.
You can create temp tables in 2 ways :
1. Create table #tablename
2. Create table tempdb..tablename
a).If you create the table as per the above mentioned ways,
the table will get dropped automatically when the
session/procedure ends or you drop it manually.
b).If you don’t use the above mentioned ways and use
only "create table table name" command in tempdb the table
will stay there as long as you drop in manually.
c).If you create a table in any other database other than
tempdb, it will not be a temp table.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is sybase replication server?
Explain relationship between jdbc and sybase.
What is an advantage to using a stored procedure as opposed to passing an sql query from an application ?
Differentiate between replication server and sql remote?
What are triggers? Why do we use them? Diff types of triggers? What are magic tables?
Is there any advantage of last_name varchar(50) over this last_name varchar(255)?
How to start sybase database in windows?
What are the operating systems in which sybase could take its presence?
Explain update statistics.
How do I configure the burn factor in sybase?
What is the timestamp datatype in sybase?
What is raid and sybase?
How to save space when inserting rows monotonically?
How do I choose which tables to partition in sybase?
What is the relationship between jdbc and sybase?