tSQL: CREATE TABLE with PRIMARY KEY

CREATE_Fragment_TABLE.sql

/*
-- Update:

IF EXISTS
(
    SELECT * FROM sysobjects
    WHERE
        name = 'Fragment'
    AND
    type = 'U'
)
DROP TABLE [dbo].[Fragment]

*/
CREATE TABLE [dbo].[Fragment]
(
    [FragmentId]            [int] IDENTITY (1, 1) NOT NULL
,   [InceptDate]            [datetime] NOT NULL
,   [ModificationDate]      [datetime] NOT NULL
,   [FragmentName]          [varchar](64) NULL
,   [FragmentDisplayName]   [varchar](255) NULL
,   [FragmentContent]       [varchar](max) NULL
,   [IsActive]              [bit] NULL
,   [SortOrdinal]           [tinyint] NULL
,   CONSTRAINT [PkFragment] PRIMARY KEY CLUSTERED([FragmentId] ASC)
)