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
what are myisam tables? : Sql dba
How do you truncate?
What is the purpose of design view?
what are date and time functions in mysql? : Sql dba
What are the steps for performance tuning.
How much does sql cost?
What is trigger types of trigger?
explain the difference between bool, tinyint and bit. : Sql dba
How to revise and re-run the last sql command?
What are system versioned tables?
What are pl sql data types?
Why do we need databases?
What is the difference between delete and truncate commands?
Can %notfound return null after a fetch?
Are left and right joins the same?
