Person.Address

Columns

• //

  ${escapify(column.description)}
  AddressID
  [int] IDENTITY (1,1) NOT NULL
• //

  ${escapify(column.description)}
  AddressLine1
  [nvarchar](60) NOT NULL
• //

  ${escapify(column.description)}
  AddressLine2
  [nvarchar](60) NULL
• //

  ${escapify(column.description)}
  City
  [nvarchar](30) NOT NULL
• //

  ${escapify(column.description)}
  StateProvinceID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  PostalCode
  [nvarchar](15) NOT NULL
• //

  ${escapify(column.description)}
  SpatialLocation
  [geography] NULL
• //

  ${escapify(column.description)}
  rowguid
  [uniqueidentifier] NOT NULL DEFAULT (newid())
• //

  ${escapify(column.description)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_Address_AddressID
  UNIQUE CLUSTERED
  AddressID
• //

  Unique nonclustered index. Used to support replication samples.
  AK_Address_rowguid
  UNIQUE NONCLUSTERED
  rowguid
• //

  Nonclustered index.
  IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
  UNIQUE NONCLUSTERED
  AddressLine1 , AddressLine2 , City , StateProvinceID , PostalCode
• //

  Nonclustered index.
  IX_Address_StateProvinceID
  NONCLUSTERED
  StateProvinceID

Foreign Keys

• //

  Foreign key constraint referencing StateProvince.StateProvinceID.
  FK_Address_StateProvince_StateProvinceID
  Person.StateProvince
  StateProvinceID ⥱ StateProvinceID

Sample Data