discuss the difference between drop table r and

Question

Discuss The difference between drop table R and delete from R. 

DROP TABLE command deletes all the records with the table definition. This command will automatically committed and cannot be rolled back. Although

DELETE FROM

command deletes just only the records; the table definition remains existed. The influence of this command may be rolled back, if needed.

Request for Solution File

Ask an Expert for Answer!!

Database Management System: discuss the difference between drop table r and

Reference No:- TGS0275959

Expected delivery within 24 Hours

Have a Question? (oR Write a Review)

Write atleast 100 words!!

   Recent Questions Asked Database Management System

Q : fan in is simply a count of the number of other fan in is simply a count of the number of other components that can call or pass control to component

Q : discuss the count functionthe count function used discuss the count functionthe count function used returns the number of tuples or values fixed in a querythe count function comprises two types of

Q : explain the check clausethe check clause is explain the check clausethe check clause is employed to at the end of a create table statement specify table constraints this is known as table-based

Q : describe other concerns in adults with congenital describe other concerns in adults with congenital heart disease infective endocarditis prophylaxis the standard guidelines for infective endocarditis

Q : discuss the difference between drop table r and discuss the difference between drop table r and delete from r drop table command deletes all the records with the table definition this command

Q : a program in execution is callednb s when a a program in execution is called ans when a program in execution is known as

Q : why is good design important for a product a why is good design important for a product a good design is the key to booming product almost 2000 years ago a roman architect recorded the

Q : shell is the exclusive feature ofans shell is the shell is the exclusive feature ofans shell is the exclusive feature of

Q : define coupling coupling is the measure of the define coupling coupling is the measure of the degree of interdependence among