Creating Unique Token At Table Level

TokenGenerationTable.Example.sql

CREATE TABLE [dbo].[tokens]
(
	[id] INT IDENTITY(1,1) NOT NULL, 
	[token] NCHAR(6) NOT NULL CONSTRAINT DF_subscribertokens_token DEFAULT CONVERT(nvarchar(6),LEFT(REPLACE(NEWID(),'-',''),6)), 
	[created] DATETIME NOT NULL CONSTRAINT DF_subscribertokens_created DEFAULT getutcdate(), 
	[notes] VARCHAR(MAX) NULL,
	[deactivated] BIT NOT NULL CONSTRAINT DF_subscribertokens_deactivated DEFAULT 0,

  	CONSTRAINT [PK_tokens] PRIMARY KEY CLUSTERED ([id] ASC),
    	CONSTRAINT UC_tokens_token UNIQUE (token)
)