-
Junior Member
sql
what is the difference between drop,truncate and delete commands?explain me with examples?
Last edited by Mekalakn; 10-17-2007 at 04:26 AM.
-
Junior Member
Re: sql
Truncate
this command will removes the data from the table
for ex
if u have a table with data if u give
truncate table-name;
command it removes the record Permanently
Delete
this command is same as truncate but Retrieves the data when we give rollback
Drop
this removes both data and struture of the table Permanently
-
Re: sql
DROP:- It removed the table from the database along with its data.
TRUNCATE:-It deletes all the records from the table and dealocates all the resources . Data deleted by truncate can't be rolled back.
DELETE:-It deletes the records from the table which can be rolled back .
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules