Moving a view from Table into Views category?

A bit bizarre we have a view called uvw_rev_rec_rpt_detail that is showing under tables in Enterprise Manager. It should be under views, I am over thinking this but what is the best way to move the view over?
Can I do a drop table command via TSQL or simply delete from Enterprise Manager?
Thanks
Strange. Could you run sp_help on that object and post the output here?
EXEC sp_help uvw_rev_rec_rpt_detail
GO
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Jeffrey Sheldon" <jsheldon@.projecthope.org> wrote in message
news:2CF8A2CA-6A12-4C93-8235-154930A5B795@.microsoft.com...
A bit bizarre we have a view called uvw_rev_rec_rpt_detail that is showing
under tables in Enterprise Manager. It should be under views, I am over
thinking this but what is the best way to move the view over?
Can I do a drop table command via TSQL or simply delete from Enterprise
Manager?
Thanks

Moving a view from Table into Views category?

A bit bizarre we have a view called uvw_rev_rec_rpt_detail that is showing u
nder tables in Enterprise Manager. It should be under views, I am over thin
king this but what is the best way to move the view over?
Can I do a drop table command via TSQL or simply delete from Enterprise Mana
ger?
ThanksStrange. Could you run sp_help on that object and post the output here?
EXEC sp_help uvw_rev_rec_rpt_detail
GO
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Jeffrey Sheldon" <jsheldon@.projecthope.org> wrote in message
news:2CF8A2CA-6A12-4C93-8235-154930A5B795@.microsoft.com...
A bit bizarre we have a view called uvw_rev_rec_rpt_detail that is showing
under tables in Enterprise Manager. It should be under views, I am over
thinking this but what is the best way to move the view over?
Can I do a drop table command via TSQL or simply delete from Enterprise
Manager?
Thanks

move table data from one filegroup to another

hi,
i wanna move table data from one filegroup to another , i
can do it in Enterprise Manager . can i use script to run
it in SQL Analyzer ?
Your answer is highly apprieated .(Re)-create a/the clustered index on the table.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"rainbow" <genghj@.routon.com> wrote in message news:02f101c3871c$05237630$a001280a@.phx.gbl...
> hi,
> i wanna move table data from one filegroup to another , i
> can do it in Enterprise Manager . can i use script to run
> it in SQL Analyzer ?
> Your answer is highly apprieated .|||What if they dont have a clustered index ..a heap or what if they just have
only non clustered indexes.
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:OUkjT5xhDHA.1952@.TK2MSFTNGP10.phx.gbl...
> (Re)-create a/the clustered index on the table.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
> "rainbow" <genghj@.routon.com> wrote in message
news:02f101c3871c$05237630$a001280a@.phx.gbl...
> > hi,
> > i wanna move table data from one filegroup to another , i
> > can do it in Enterprise Manager . can i use script to run
> > it in SQL Analyzer ?
> > Your answer is highly apprieated .
>|||That's why Tibor put (RE)Create
It means recreate the clustered index if you have one, or create one if you
don't. You can drop the clustered index afterward if you really don't want
to keep it, but you should really have a good reason NOT to have a clustered
index on a table.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u6a#ep3hDHA.1200@.TK2MSFTNGP09.phx.gbl...
> What if they dont have a clustered index ..a heap or what if they just
have
> only non clustered indexes.
> "Tibor Karaszi"
<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> wrote in message news:OUkjT5xhDHA.1952@.TK2MSFTNGP10.phx.gbl...
> > (Re)-create a/the clustered index on the table.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at: http://groups.google.com/groups?oi=djq&as
> ugroup=microsoft.public.sqlserver
> >
> >
> > "rainbow" <genghj@.routon.com> wrote in message
> news:02f101c3871c$05237630$a001280a@.phx.gbl...
> > > hi,
> > > i wanna move table data from one filegroup to another , i
> > > can do it in Enterprise Manager . can i use script to run
> > > it in SQL Analyzer ?
> > > Your answer is highly apprieated .
> >
> >
>