Owner: Person 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB: 2224 
Index Size KB: 2440 
Rows: 19614 
Description: Street address information for customers, employees, and vendors. 


Name Data Type Length NULL Default IsIdentity IsGUID Description
    AddressID  int          Primary key for Address records. 
    AddressLine1  nvarchar  60          First street address line. 
    AddressLine2  nvarchar  60          Second street address line. 
    City  nvarchar  30          Name of the city. 
    StateProvinceID  int          Unique identification number for the state or province. Foreign key to StateProvince table. 
    PostalCode  nvarchar  15          Postal code for the street address. 
    rowguid  uniqueidentifier  16    (newid())      ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 8 column(s)

Identity column

Name Seed Increment Not for replication


Index Primary Unique Description
  PK_Address_AddressID      Primary key (clustered) constraint 
  IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode      Nonclustered index. 
  IX_Address_StateProvinceID      Nonclustered index. 
  AK_Address_rowguid      Unique nonclustered index. Used to support replication samples. 
Total: 4 index(es)

Referencing Tables

Table Foreign Key Primary Key or Unique Constraint
  Sales.SalesOrderHeader  FK_SalesOrderHeader_Address_BillToAddressID  PK_Address_AddressID 
  Sales.SalesOrderHeader  FK_SalesOrderHeader_Address_ShipToAddressID  PK_Address_AddressID 
  Purchasing.VendorAddress  FK_VendorAddress_Address_AddressID  PK_Address_AddressID 
  Sales.CustomerAddress  FK_CustomerAddress_Address_AddressID  PK_Address_AddressID 
  HumanResources.EmployeeAddress  FK_EmployeeAddress_Address_AddressID  PK_Address_AddressID 
Total: 5 table(s)

Referenced Tables

Table Foreign Key Primary Key or Unique Constraint
  Person.StateProvince  FK_Address_StateProvince_StateProvinceID  PK_StateProvince_StateProvinceID 
Total: 1 table(s)

Objects that [Person].[Address] depends on

Object Name Owner Object Type Dep Level
  Flag  dbo  User Defined type 
  Name  dbo  User Defined type 
  CountryRegion  Person  Table 
  SalesTerritory  Sales  Table 
  StateProvince  Person  Table 
Total: 5 object(s)

Objects that depend on [Person].[Address]

Object Name Owner Object Type Dep Level
  CustomerAddress  Sales  Table 
  EmployeeAddress  HumanResources  Table 
  SalesOrderHeader  Sales  Table 
  VendorAddress  Purchasing  Table 
  vEmployee  HumanResources  View 
  vIndividualCustomer  Sales  View 
  vSalesPerson  Sales  View 
  vSalesPersonSalesByFiscalYears  Sales  View 
  vStoreWithDemographics  Sales  View 
  vVendor  Purchasing  View 
  SalesOrderDetail  Sales  Table 
  SalesOrderHeaderSalesReason  Sales  Table 
  uSalesOrderHeader  Sales  Trigger 
  iduSalesOrderDetail  Sales  Trigger 
Total: 14 object(s)


CREATE TABLE [Address] (
    [AddressLine1] [nvarchar] (60) COLLATE Latin1_General_CS_AS NOT NULL ,
    [AddressLine2] [nvarchar] (60) COLLATE Latin1_General_CS_AS NULL ,
    [City] [nvarchar] (30) COLLATE Latin1_General_CS_AS NOT NULL ,
    [StateProvinceID] [int] NOT NULL ,
    [PostalCode] [nvarchar] (15) COLLATE Latin1_General_CS_AS NOT NULL ,
    [rowguid]  uniqueidentifier ROWGUIDCOL  NOT NULL CONSTRAINT [DF_Address_rowguid] DEFAULT (newid()),
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_Address_ModifiedDate] DEFAULT (getdate()),
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_Address_StateProvince_StateProvinceID] FOREIGN KEY
    ) REFERENCES [StateProvince] (

See Also

List of tables