Wednesday, March 28, 2012

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

No comments:

Post a Comment