Filter by Tags

SQL related question

Votes

0

0 0

What is the difference between delete and drop in SQL?

Nidhi Gupta
Posted on : Tue, May 23, 2017
Views : 101
Comments

Ask Question

If you want to ask question you must LogIn or SignUp
Login SignUp

Answers (1)


0
Drop command is used to remove the table from the database. It will also delete the indexes and privileges to a table whereas delete command is used to delete the records of a table leaving its structure untouched. Also,It is a DDL command so delete operation can be rollbacked whereas Drop can’t be rollback.
Nidhi Gupta
Thu, May 25, 2017
Loading...
Comments

Edit Answer

Submit
This answer will permanently deleted. Do you really want to delete this Answer ?
To Add your Answer Please
LogIn | SignUp

Quick Links

E-Magazines

@

Total Followers
Study Group Created
Study Group Joined
Following Teacher
Following Organization
Blog Articles Added
Questions Asked
Questions Answered
Jobs Posted
Total Members in Group
Questions asked by members
Tasks added in this Group

Please wait..

Ok

Login to Open ESchool OR Create your account    Login   SignUp