Drop table command, Database Management System

DROP TABLE Command:

When an existing object is not needed for further use, it is always better to eliminate it from the database. To remove the existing object from the database the following command is used.

Syntax:

 DROP TABLE

; Example 4:

DROP TABLE emp;

 

Posted Date: 3/11/2013 12:57:45 AM | Location : United States







Related Discussions:- Drop table command, Assignment Help, Ask Question on Drop table command, Get Answer, Expert's Help, Drop table command Discussions

Write discussion on Drop table command
Your posts are moderated
Related Questions
Describe the GRANT function and explain, how it associates to security. What kind of privileges may be granted? How are they revoked? Ans: Since more than one user can aacce

What is the function of a Domain? A domain defines the technical settings of a table field. A domain describes a value range, which sets the permissible data values for the

Define Serializable schedule Serializable schedule: An interleaved schedule of much more than one transaction is known as a serializable schedule, if it is equal to some serial

Making Common Behaviour Abstract Let us define abstraction "Abstraction means to focus on the necessary, inherent aspects of an entity and ignoring its accidental features". O

Define the concept of aggregation.  Give two examples where this concept is useful. Ans: Aggregation transforms a relationship among the objects into a higher-level object. A

Question: (a) What are the challenges in the development of Large Scale Distributed Real Systems? (b) What is backward engineering and forward engineering in a design packa

10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the delet

What are the benefits of decomposing a system? The benefits of decomposing a system into subsystems are that after decomposition, each individual component become smaller and e


What are multiple inheritances? Multiple inheritances allow a class to inherit variables and methods from many super classes.