asked
Syntax for replacing a view
I am trying to add a column into an existing view named CURRENT PRODUCT LIST. The column exists in the table that the view was created from. When I try to replace the view using the following syntax, REPLACE VIEW [CURRENT PRODUCT LIST] AS SELECT ProductID, ProductName, ProductLoc FROM dbo.OuterWear WHERE ProductLoc = Groveport; GO I get the following error message. Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'VIEW'. Any suggestions for how I might accomplish this? Thank you in advance for your help!
The site runs on voting. Please indicate all helpful answers by clicking on the thumbs up symbols next to those answers. Please indicate any one answer that lead to the best solution by clicking on the check mark next to that answer.
Replace View will not work for the SQL, it works for Oracle. In SQL Server you need to write ALTER VIEW instead of Replace!
As with the other post on a similar subject, I strongly recommend that learn how to use Books Online and then use it. These are basic questions that a bit of self study on your part will take care of. The other thing to remember is that "SQL is NOT SQL". Despite the best attempts at ANSI and ISO compliance, no RDBMS engine follows all the rules nor do they have identical syntax in all cases. Oracle and SQL server are great examples of how far apart the language for two RDBMSs can actually be. It'll also save you a whole lot of time because, once you've learned a little about what to look for, finding answers in Books Online is a whole lot faster than posting a question and hoping someone answers it for you.
17 People are following this question.
