Diff between Delete from table and delete * from table

Question

1.33/5 (3 votes)

See more:

SQL-Server-2012

Can any one explain the reason
Difference between delete from Table and Delete * from table in sql server
Thanks in Advance

Posted 1-Sep-15 5:19am

Member 11951055

Add a Solution

Comments

PIEBALDconsult 1-Sep-15 12:40pm

By the way: "If you want to delete all the rows in a table, TRUNCATE TABLE is faster than DELETE. TRUNCATE TABLE is functionally equivalent to DELETE with no WHERE clause, but TRUNCATE TABLE cannot be used with tables referenced by foreign keys."

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andy Lanng · Accepted Answer · 2015-09-01T05:34:00

Solution 1

There is none ^_^

In older versions only delete * from table was used, but as delete (not everything) from table made no sense they introduced delete table. They kept the old syntaxt so as not to break any older scripts.

FYI: Delete From table is also valid (and the preferred syntax) ^_^

Posted 1-Sep-15 5:34am

Andy Lanng

Updated 1-Sep-15 5:37am

v2

Comments

Advay Pandya 2-Sep-15 2:20am

Good information Andy... 5ed