Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the basic common difference among delete, truncate, and drop?

*IMP* if possible than explain example too ..

Databases
user-image
Question added by Ganesh Pandey
Date Posted: 2013/07/27
Upvote (0) Views (2) Followers (0) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
Deleted user
by Deleted user

Delete removes Rows from a Table,Truncate removes all Rows from Table and Drop removes table from Database.
Drop and Truncate is DDL command and Delete is a DML command.

Write Your Answer
More Questions Like This