title: Add a new column to a view in SQL
body: <p>I have a database and I've made a view with the data I want. The data looks something like this:</p>
  
  <pre><code>    n     |   value |
  ----------+---------+
   50404791 |     112 | 
    5034591 |     164 |
   50280287 |      31 |
  </code></pre>
  
  <p>I want to add a column of text like this:</p>
  
  <pre><code>    n     |   value | status |
  ----------+---------+--------+
   50404791 |     112 |default | 
    5034591 |     164 |biggest |
   50280287 |      31 |smallest|
  </code></pre>
  
  <p>I tried <code>Alter Table Table1 Add Column status text ;</code> but it seems like text is not a data type. Any suggestions what to do?</p>