title: Msg 207, Level 16, State 1 "Invalid column name 'Name'"
body: <p>I'm trying to drop and recreate a table with a new schema in SQL Server, and then insert some test data into it to validate that it's working correctly. I have the following DDL:</p>
  
  <pre><code>CREATE TABLE [dbo].[Product](
      [ID] int IDENTITY(1,1) PRIMARY KEY,
      [Name] VARCHAR(100) NOT NULL,
      [Description] VARCHAR(200) NULL,
      [Modified] DATETIME NOT NULL DEFAULT(GETUTCDATE()),
      [ModifiedBy] VARCHAR(32) NOT NULL
  );
  </code></pre>
  
  <p>and the following insert statement:</p>
  
  <pre><code>INSERT INTO [dbo].[Product]([Name], [Description], [Modified], [ModifiedBy])
  VALUES('Test', 'Description', GETUTCDATE(), 'Me');
  </code></pre>
  
  <p>Whenever I attempt to insert the aforementioned row, I get an error:</p>
  
  <blockquote>
    <p>Msg 207, Level 16, State 1, Line 38
    Invalid column name 'Name'.</p>
    
    <p>Msg 207, Level 16, State 1, Line 38
    Invalid column name 'Description'.</p>
  </blockquote>
  
  <p>I know the table is there since I can <code>SELECT * FROM Product</code> and get an empty result set with the correct columns and no errors... I just can't insert into it for some reason. Any help would be greatly appreciated!</p>