Method 1:
CREATE TABLE [dbo].[TestTable](
[ID] [int] IDENTITY(1,1) NOT NULL,
[FirstName] [varchar](100) NULL)
GO
ALTER TABLE [dbo].[TestTable] ADD  CONSTRAINT  [PK_TestTable] PRIMARY KEY CLUSTERED
([ID]  ASC)
GO  
Method 2:
CREATE TABLE [dbo].[TestTable](
[ID] [int] IDENTITY(1,1) NOT NULL,
[FirstName] [varchar](100) NULL,
CONSTRAINT [PK_TestTable] PRIMARY KEY CLUSTERED
([ID]  ASC)
)
GOHowever it would look very normal to all experienced developers, it can be still confusing to many.
 
 
No comments:
Post a Comment