title: How can I add a timestamp column to my SQL Server table when I create it?
body: <p>I am trying to use the following:</p>
  
  <pre><code>CREATE TABLE [dbo].[Application] (
      [ApplicationId]   INT            IDENTITY (1, 1) NOT NULL,
      [Name] NVARCHAR (MAX) NULL,
      timestamp
      CONSTRAINT [PK_dbo.Application] PRIMARY KEY CLUSTERED ([ApplicationId] ASC)
  );
  </code></pre>
  
  <p>Can someone confirm if this is the correct way. Also can or should I give that column a name of its own?</p>
  
  <p><em>*</em> Note that I am using Entity Framework. So is it okay to add a column like this but to not add it to the Application object?</p>