Owner: Person 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB:
Index Size KB: 40 
Description: Types of addresses stored in the Address table.  


Name Data Type Length NULL Default IsIdentity IsGUID Description
    AddressTypeID  int          Primary key for AddressType records. 
    Name  Name  100          Address type description. For example, Billing, Home, or Shipping. 
    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: 4 column(s)

Identity column

Name Seed Increment Not for replication


Index Primary Unique Description
  PK_AddressType_AddressTypeID      Primary key (clustered) constraint 
  AK_AddressType_Name      Unique nonclustered index. 
  AK_AddressType_rowguid      Unique nonclustered index. Used to support replication samples. 
Total: 3 index(es)

Referencing Tables

Table Foreign Key Primary Key or Unique Constraint
  Purchasing.VendorAddress  FK_VendorAddress_AddressType_AddressTypeID  PK_AddressType_AddressTypeID 
  Sales.CustomerAddress  FK_CustomerAddress_AddressType_AddressTypeID  PK_AddressType_AddressTypeID 
Total: 2 table(s)

Objects that [Person].[AddressType] depends on

Object Name Owner Object Type Dep Level
  Name  dbo  User Defined type 
Total: 1 object(s)

Objects that depend on [Person].[AddressType]

Object Name Owner Object Type Dep Level
  CustomerAddress  Sales  Table 
  VendorAddress  Purchasing  Table 
  vIndividualCustomer  Sales  View 
  vStoreWithDemographics  Sales  View 
  vVendor  Purchasing  View 
Total: 5 object(s)


CREATE TABLE [AddressType] (
    [AddressTypeID] [int] IDENTITY (1, 1) NOT NULL ,
    [Name] [Name] NOT NULL ,
    [rowguid]  uniqueidentifier ROWGUIDCOL  NOT NULL CONSTRAINT [DF_AddressType_rowguid] DEFAULT (newid()),
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_AddressType_ModifiedDate] DEFAULT (getdate()),
    )  ON [PRIMARY]

See Also

List of tables