Wednesday, March 7, 2012

Drop a table

I tried to drop a table in Enterprise Manager but it won't allow me and it's
just a user table. How else can I drop it? Thanks.Can you give us the error message?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"00kobebrian" <abc@.yahoo.com> wrote in message news:%23r0w1vonGHA.764@.TK2MSFTNGP03.phx.gbl...
>I tried to drop a table in Enterprise Manager but it won't allow me and it's just a user table. How
>else can I drop it? Thanks.
>
>|||I hate to be the guy who asks this, but do make sure that you refresh
the treeview on the left after you drop. This happened to me once and I
was stumped for a long time. Finally, I closed enterprise manager and
restarted. Then I realized that the table dropped, but it wasn't being
reflected in the view.
Tibor Karaszi wrote:
> Can you give us the error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "00kobebrian" <abc@.yahoo.com> wrote in message news:%23r0w1vonGHA.764@.TK2MSFTNGP03.phx.gbl...
> >I tried to drop a table in Enterprise Manager but it won't allow me and it's just a user table. How
> >else can I drop it? Thanks.
> >
> >
> >
> >|||"Rich" <rich@.adgooroo.com> wrote in message
news:1151941402.034081.206570@.j8g2000cwa.googlegroups.com...
> I hate to be the guy who asks this, but do make sure that you refresh
> the treeview on the left after you drop. This happened to me once and I
> was stumped for a long time. Finally, I closed enterprise manager and
> restarted. Then I realized that the table dropped, but it wasn't being
> reflected in the view.
BTW, you wouldn't be the first person to do this. :-)
>
> Tibor Karaszi wrote:
> > Can you give us the error message?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "00kobebrian" <abc@.yahoo.com> wrote in message
news:%23r0w1vonGHA.764@.TK2MSFTNGP03.phx.gbl...
> > >I tried to drop a table in Enterprise Manager but it won't allow me and
it's just a user table. How
> > >else can I drop it? Thanks.
> > >
> > >
> > >
> > >
>

No comments:

Post a Comment