Need help altering an existing VIEW in ADP

[socomfort]

Hey guys,

I am trying to alter an existing VIEW in a ADP. The following statement is not working and I'm not sure what the correct syntax is:

ALTER VIEW dbo.zView2 (Field1, Field2, Field3, Field4) AS
SELECT Field1, Field2, Field3, Field4 FROM dbo.zView1

I have tried this and ALTER PROCEDURE and each time I receive the error message "Invalid syntax near the word PROCEDURE/VIEW".

Thanks for any help you can provide.

-Ben

 

[PWise]

if you want to alter the view in the adp right click on the view and select design view and change the view