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

Ask an Expert

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

Write your message here..

Related Questions

Define the third normal form, Define the Third Normal Form: The third ... Define the Third Normal Form: The third normal form (3NF) is a normal form employed in database normalization. 3NF was initially defined by E.F. Codd in 1971. Codd's definitio

What is horizontal fragmentation, What is horizontal fragmentation? Hor... What is horizontal fragmentation? Horizontal fragmentation divides the relation by assuming every tuple of r to one or more fragments

Which two files are used during operation of the dbms, Which two files are ... Which two files are used during operation of the DBMS? Data dictionary and transaction log are two files used during operation of the DBMS.

Unit database integrity, Relations create the database. They must satisfy v... Relations create the database. They must satisfy various properties, like no duplicate tuples, no ordering of tuples, and atomic attributes, etc. Relations that satisfy these basic

Explain the concepts of relational data model, Explain the concepts of rela... Explain the concepts of relational data model? Relational Data Model - The relational model was first introduced through Prof. E.F. Codd of the IBM Research in the year 1970

Explain the two types of participation constraint., Explain the two types o... Explain the two types of participation constraint. 1. Total: The participation of an entity set E in a relationship set R is said to be total if each entity in E participates i

Indexed (indexed sequential) file organisation, Indexed (Indexed Sequential... Indexed (Indexed Sequential) File Organisation It organises the file like a big dictionary, i.e., records are kept in order of the key but an index is stored which also allows

Define the terms entity, Define the terms entity, attribute, role and relat... Define the terms entity, attribute, role and relationship between the entities, giving examples for each of them.         Ans: Entity:   An entity is a "thing" or "object" in th

Data modelling and normalization methodology, MOSS VALE is a town with 1500... MOSS VALE is a town with 15000 inhabitants. The fire department wishes to develop a system that automates the despatch of fire engines to attend fires. The ERD below describes the

Reflects organisational structure, Reflects organisational structure: Many ... Reflects organisational structure: Many organizations are distributed over various locations. If an organisation has many offices in dissimilar cities, databases used in such an ap