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
Databases and data warehouses both are databases and both contains number of rows and columns of tables containing data. Data warehouse is really different from databases because d

Vertical Fragmentation- Vertical fragmentation groups together only those attributes in a relation that are used jointly by various important transactions. A vertical fragment is d

You are required to design and build a data mart/data warehouse using Oracle. A national bank allocates funding every year for its local branches to provide temporary staff cove

In E-R Diagram how derived attribute are represented ? In E-R Diagram By Dashed ellipse derived attribute are represented.

Un-Normalized Form (UNF) If a table having non-atomic values at every row, it is said to be in UNF. An atomic value is something that cannot be further decomposed. A non-atomic

losers with new information systems

Association as a cache This association must be updated when any new element is added to it, but testing for overlap using association is more efficient.    Figure:

What are stored-procedures? And what are the advantages of using them? Stored procedures are database objects that perform a user defined operation. A stored procedure can have

1. Design the logic, using a looping structure, for a program that outputs every even number from 1 through 25 along with its square and cube. 2. Mr. Sanchez owns 12 apartme

What's the difference between a primary key and a unique key? Both primary key and unique key enforces uniqueness of the column on which they are explained. But by default prim