How to add new column in existing View in SQL-Server 2014 using Alter : <p>I have created a view that is based on another view and a table. I want to add new column of type varchar. I did like below, But getting syntax error?
I am new to SQL, So,could not understand</p>

<pre><code>ALTER VIEW [dbo].[MyView]
ADD New_Col varchar(10) null 
GO
</code></pre>
