What is use of generating such tables, Database Management System

What is use of generating such tables? How can you create temporary tables?

When you require a table only for a short time after that you want it to disappear automatically you can go to generate a temporary table. This is extremely useful behaviour as you needn't remember to eliminate the table

 Temporary tables can be created using the keyword CREATETEMPORARY TABLE

 

Posted Date: 7/31/2013 2:13:09 AM | Location : United States







Related Discussions:- What is use of generating such tables, Assignment Help, Ask Question on What is use of generating such tables, Get Answer, Expert's Help, What is use of generating such tables Discussions

Write discussion on What is use of generating such tables
Your posts are moderated
Related Questions
What is storage manager?  A  storage  manager  is  a  program  module  that  gives  the  interface  between the Low level data  kept in a database and the application programs

Which is a valid SQL type? A valid SQL Should be in CHARACTER it is should be NUMERIC and FLOAT.

Advantages of Database management system Let us summarize the advantages. Reduction of Redundancy: This is perhaps the most important advantage of using DBMS. Redundancy i


design a generalization specialization hierarchy for a motor vehicle sales company. the company sells motorcycles, passenger cars, vens and buses.

Explain natural join? Natural Join - Similar as equi-join except in which the join attributes (having similar names) are not involved in the resulting relation. Only one sets

Explain heap file with advantages? Heap File is an unordered set or a group of records, stored on a set of pages. This class gives basic support for inserting, updating, select

sql is relationally complete-justify

System error :These contain errors in database system or the OS, example, deadlocks.Such errors are fairly hard to detect and need reprogramming the erroneous components of the sys

Define the basic operations of the relational algebra?     Ans: Basic operators of relational algebra are: 1. Union (∪) - Selects tuples which are in either P or Q or in bot