title: Altering SQL table to add column
body: <p>I currently have a table with four columns - i wanted to add a fifth column but having some trouble. </p>
  
  <p>I open the table in sql server studio management 2008 and i added the column info like so: </p>
  
  <pre><code>CREATE TABLE [dbo].[Case]
  (
      CaseId                  UNIQUEIDENTIFIER DEFAULT (newid()) NOT NULL,
      CaseNumber              NVARCHAR(50) NOT NULL,
      CourtId                 INT NOT NULL,
      DateOpened              DATETIME NOT NULL,
  ) 
  </code></pre>
  
  <p>my addition: </p>
  
  <pre><code>CREATE TABLE [dbo].[Case]
  (
      CaseId                  UNIQUEIDENTIFIER DEFAULT (newid()) NOT NULL,
      CaseNumber              NVARCHAR(50) NOT NULL,
      CaseName                NVARCHAR(50),
      CourtId                 INT NOT NULL,
      DateOpened              DATETIME NOT NULL,
  )
  </code></pre>
  
  <p>After adding CaseName column, i tried executing the table in Management Studio but i got the error message "There is already an object named 'Case' in the database."
  I tried saving and then building my database hoping that the column will be added but that wasn't successful. I tried a New Query and writing the 'Alter table "case" add CaseName nvarchar(50) but again without luck. It shows that the file is changed with the new column because i saved it but after building my overall database it isn't making any changes. Any helpful tips will be great. </p>