Just a quick question.
I am studying for the Microsoft SQL Server 2014 - 70-461 exam and had a quick question regarding Altering Views.
If I am to alter a view after creating the view, I know you can use the ALTER VIEW in the script, however, my question is how do you get the script for the current view query? Is the only way to use the script option and ALTER to when right-clicking on the view. This would save time rather than remembering the view query. Would this way of altering a view be allowed as an example if it came up in the exam?
Thanks in advance