Dropping Tables

#1

Using Management Studio with SQL 2005 or 2008, does deleting a table have
the same effect as dropping a table?

#2

You can't delete a table you can only drop it. The gui issues a DROP behind
the scenes.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Jeffery Rehm" <abs (AT) spam (DOT) never> wrote

Quote:

Using Management Studio with SQL 2005 or 2008, does deleting a table have
the same effect as dropping a table?

#3

That's what I was thinking, but wasn't sure. Thanks.

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

You can't delete a table you can only drop it. The gui issues a DROP
behind the scenes.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Jeffery Rehm" <abs (AT) spam (DOT) never> wrote in message
news:uOm28vxzJHA.4116 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Using Management Studio with SQL 2005 or 2008, does deleting a table have
the same effect as dropping a table?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Dropping Tables

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Dropping Tables - 05-07-2009 , 08:52 AM

Re: Dropping Tables - 05-07-2009 , 09:04 AM

Re: Dropping Tables - 05-07-2009 , 09:23 AM