add bool column within existing table
<p>I am trying to dd a column, to a database with the program Microsoft SQL Server Management Studio.</p>

<p>I already have a database, with a table, in that table i need to add another column.. but it keeps saying it cannot find type bool or boolean.</p>

<p>my code : </p>

<pre><code>ALTER TABLE table_name ADD IsOpen boolean GO
</code></pre>

<p>Any ideas ?</p>

<p>side question, any idea how to alter an existing column ? i have a column called "budget" but it needs to be "Budget". </p>