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
Cardinality of Relationship One-to-One Only one entity of the first set is linked to only one entity of the second set. E.g. A teacher teaches a student. Only one teacher

need to get answer for questions 3&4 on this page in part 1

Define outer union operation of the relational algebra. Compute the outer union for the relations R and S given below. Outer Join - If there are any values in one tabl

Question 1: (a) Explain the legal meaning of :- (i) Computer Service Person (ii) Data holding (b) Explain how the law ensures Data protection and Security. Qu

Views A view is like a window by which data from tables can be changed or viewed. The table on which a view is based is known as Base table. The view is stored as a SELECT stat

The PROJECT operation The project operation is used to choose the records with specified attributes as discarding the others based on some related criteria. This is denotes as ∏

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

Durability : This property necessitates that once a transaction has committed, the changes made by it be never lost because of subsequent failure. Thus, a transaction is also a bas

how to make an e r diagram?

Define entity integrity and referential integrity.  How does SQL allow specification of  these? Ans: Entity Integrity Rule- If the attribute A of relation R is a prime attribut