CREATE TABLE [dbo].[IntKeyIdentity](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](50) NULL,
CONSTRAINT [PK_IntKeyIdentity] PRIMARY KEY CLUSTERED ([id] ASC))

CREATE TABLE [dbo].[IntKey](
[Id] [int] NOT NULL,
[Name] [varchar](50) NULL,
CONSTRAINT [PK_IntKey] PRIMARY KEY CLUSTERED ([id] ASC))

CREATE TABLE [dbo].[GuidKeyClustered](
[Id] [uniqueidentifier] NOT NULL,
[Name] [varchar](50) NULL
CONSTRAINT [PK_GuidKeyClustered] PRIMARY KEY CLUSTERED ([id] ASC))

CREATE TABLE [dbo].[SequentialGuidKeyClustered](
[Id] [uniqueidentifier] NOT NULL,
[Name] [varchar](50) NULL
CONSTRAINT [PK_SequentialGuidKeyClustered] PRIMARY KEY CLUSTERED ([id] ASC))

CREATE TABLE GuidKeyNonClustered
(Id UNIQUEIDENTIFIER NOT NULL,
CId INT IDENTITY(1,1) NOT NULL,
[Name] [varchar](50) NULL)

ALTER TABLE GuidKeyNonClustered
ADD CONSTRAINT PK_GuidKeyNonClustered
PRIMARY KEY NONCLUSTERED (Id)
CREATE UNIQUE CLUSTERED INDEX CIX_GuidKeyNonClustered ON GuidKeyNonClustered(CId)