Create table with UNIQUEIDENTIFIER as PK

sql, t-sql

Solution

create table [dbo].[AgentRelationshipCodes]
(
    Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY DEFAULT NEWID(),
    .
    .
    .
)

Repeat for the other tables.

- Answered here by Christian Hayter

Problem

I have been trying (unsuccessfully) to create a table with a `UNIQUEIDENTIFIER` as the primary key. The script below will create the table just fine, however there is no PK specified. This is my first time using a UNIQUEIDENTIFIER, however. Any ideas? T-SQL ``` CREATE TABLE [dbo].[AgentRelationshipCodes] ( Id UNIQUEIDENTIFIER NOT NULL DEFAULT NEWID(), RelationshipId char(3) NULL, EffectiveDate datetime NULL, LastChangeDate datetime NOT NULL, LastChangeId char(6) NOT NULL, AgtTableId int FOREIGN KEY REFERENCES AgentTransmission(ID) ); ``` Management Studio

Original source