alter a view in a stored procedure

[Guest_imported]

can i execute an "alter view" statement in a stored procedure with ms sql server

 

[rajeevnandanmishra]

Hi there,
You can not execute ALTER VIEW because i think there is no such command. But what you can do is CREATE VIEW

 

[Guest_imported]

Thank you!
I think there is a "alter view" command but the thing is when execute it within a stored procedure. It gives me error!

Thank you anyway!

 

[rajeevnandanmishra]

Sorry, But i am working on SQL 6.5

 

[tlbroadbent]

What is the error? Knowing more detail helps us answer the question.

Thanks, Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes