abroadbent

CREATE TABLE Countries (
  Id  int IDENTITY(1,1) NOT NULL,
  Iso  varchar(2) NOT NULL,
  Name  varchar(80) NOT NULL,
  Iso3  varchar(3) NULL,
  NumCode int  NULL,
  PhoneCode int NOT NULL,
  CONSTRAINT [PK_Countries] PRIMARY KEY CLUSTERED ([Id] ASC),
  CONSTRAINT [uc_Countries_Iso] UNIQUE NONCLUSTERED ([Iso] ASC)
)