Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / subhendu
Features:
1. If the TRUNCATE statement is issued against a temporary
table, only the session specific data is trucated. There is
no affect on the data of other sessions.
2. Data in temporary tables is automatically delete at the
end of the database session, even if it ends abnormally.
3. Indexes can be created on temporary tables. The content
of the index and the scope of the index is that same as the
database session.
4. Views can be created against temporary tables and
combinations of temporary and permanent tables.
5. Temporary tables can have triggers associated with them.
Export and Import utilities can be used to transfer the
table definitions, but no data rows are processed.
| Is This Answer Correct ? | 5 Yes | 7 No |
Post New Answer View All Answers
How do you determine the current isolation level? : Transact sql
What are the three forms of normalization?
What is the cause of mutating table error and how can we solve it?
How to get unique records from a table?
what is log shipping? : Sql dba
Why use subqueries instead of joins?
What is java sql drivermanager?
How can you save or place your msg in a table?
Is time a data type in sql?
Is big data nosql?
Is it possible for a table to have more than one foreign key?
Can you rollback after commit?
How many types of indexes are there in sql?
how do you know the version of your mysql server? : Sql dba
How can I delete duplicate rows?
