title: Altering a View to add a column as bit not null
body: <p>I'm trying to add a column to a view using <code>ALTER VIEW</code> but it keeps saying 'The column is invalid'. I need the column to be BIT NOT NULL. How would I go about doing this?  Thank you all!</p>
  
  <pre><code>SELECT dbo.tbl_skins.skinName, dbo.tbl_prefs.PersonID, dbo.tbl_prefs[columnName] etc... 
  FROM dbo.tbl_prefs 
  INNER JOIN dbo.tbl_skins 
     ON dbo.tbl_prefs.skinId = dbo.tbl_skins.skinId
  </code></pre>
  
  <p>I didn't add the rest of the columns because the rest are all from <code>dbo.tbl_prefs</code>. The only one that is different is that first one that reads <code>dbo.tbl_skins.skinName</code>.</p>
  
  <p>Upon opening the table I see, </p>
  
  <pre><code>SELECT TOP (1000) [column1],[column2], etc... FROM [table_name].
  </code></pre>
  
  <p>All I'm trying to do is add a new column of type BIT, NOT NULL to the table (<code>dbo.tbl_prefs</code>) and the same to the view (<code>dbo.qry_prefs</code>).</p>