 <p><strong><code>Int</code></strong> is the Best type for Id column in a table in SQL Server </p> <p>If the table eventually has too many records we can change to <code>BigInt</code></p> <p>We can also create the Id as the Identity and/or PK of the table. </p> <pre><code>CREATE TABLE [dbo].[TableName]( [TableNameId] [int] IDENTITY(1,1) NOT NULL ) ON [PRIMARY] </code></pre> <p>Example of Identity &amp; Primary Key</p> <pre><code>CREATE TABLE [dbo].[TableName3]( [TableName3Id] [int] IDENTITY(1,1) NOT NULL, CONSTRAINT [PK_TableName3] PRIMARY KEY CLUSTERED ( [TableName3Id] ASC ) ) </code></pre> <p>Hope this helps your question helped me. </p>