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
File Organisation And Its Types  Just as arrays, trees, lists and other data structures are used to execute data Organisation in main memory, a number of planning's are used to

Describe the responsibilities of the DBA and the database designer ? The responsibilities of DBA and database designer are: 1. Planning for the database's future storage needs

What is a foreign key, and what is it used for? A foreign key is used to establish relationships between relations in the relational model. Technically, a foreign key is a colu

Explain five duties of Database Administrator? 1. DBA administers the three stages of the database and, in consultation along with the whole user community, sets up an defin

folding method and mid square method using visual basic

Define instance and schema? Instance: Collection of data stored in the data base at a certain moment is Schema: The overall design of the data base is known as the data base


It is not possible to make an ABAP/4 program, which having only Subroutines. False. We can make ABAP/4 program, which having only Subroutines.

What is Secondary Index While making the index, generally the index table is kept in the primary memory (RAM) and the main table, because of its size is keeps in the secondary

Why did SAP introduce the extended star schema? Explain why it is reported to be better than the traditional schema model?