Difference in deleting method

26 Jan 2006 5:04 PM

jw56578

What is the difference in doing a

Delete Table where x=y

VS.

Delete From Table where x=y

26 Jan 2006 5:24 PM

Tibor Karaszi

In SQL Server: none.

In TSQL, the word FROM is optional. In ANSI SQL, it is not optional.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

<jw56***@gmail.com> wrote in message news:1138295047.562910.231670@g49g2000cwa.googlegroups.com...
> What is the difference in doing a
>
> Delete Table where x=y
>
> VS.
>
> Delete From Table where x=y
>

26 Jan 2006 5:37 PM

Edgardo Valdez, MCSD, MCDBA

No difference.

Per Books Online

"FROM

Is an optional keyword that can be used between the DELETE keyword and the
target table_name, view_name, or rowset_function_limited.
"

Show quote

"jw56***@gmail.com" wrote:

> What is the difference in doing a
>
> Delete Table where x=y
>
> VS.
>
> Delete From Table where x=y
>
>

26 Jan 2006 5:37 PM

Mark Williams

There is no difference; the FROM keyword is optional, but I like to use it
because it sounds less menacing than 'DELETE TABLE'. (which is really
accomplished by DROP TABLE or TRUNCATE TABLE).

--

Show quote

"jw56***@gmail.com" wrote:

> What is the difference in doing a
>
> Delete Table where x=y
>
> VS.
>
> Delete From Table where x=y
>
>

26 Jan 2006 9:59 PM

jw56578

cool, good answer, thanks

Mark Williams wrote:
Show quote

> There is no difference; the FROM keyword is optional, but I like to use it
> because it sounds less menacing than 'DELETE TABLE'. (which is really
> accomplished by DROP TABLE or TRUNCATE TABLE).
>
>
> --
> "jw56***@gmail.com" wrote:
>
> > What is the difference in doing a
> >
> > Delete Table where x=y
> >
> > VS.
> >
> > Delete From Table where x=y
> >
> >