Owner: | Person |
Creation Date: | 04/26/2006 |
Located On: | PRIMARY |
Data Size KB: | 8 |
Index Size KB: | 40 |
Rows: | 6 |
Description: | Types of addresses stored in the Address table. |
Name | Data Type | Length | NULL | Default | IsIdentity | IsGUID | Description | ||
AddressTypeID | int | 4 | 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 | 8 | (getdate()) | Date and time the record was last updated. |
Name | Seed | Increment | Not for replication | |
AddressTypeID | 1 | 1 |
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. |
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 |
Objects that [Person].[AddressType] depends on
Object Name | Owner | Object Type | Dep Level | |
Name | dbo | User Defined type | 1 |
Objects that depend on [Person].[AddressType]
Object Name | Owner | Object Type | Dep Level | |
CustomerAddress | Sales | Table | 1 | |
VendorAddress | Purchasing | Table | 1 | |
vIndividualCustomer | Sales | View | 2 | |
vStoreWithDemographics | Sales | View | 2 | |
vVendor | Purchasing | View | 2 |
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()),
CONSTRAINT [PK_AddressType_AddressTypeID] PRIMARY KEY CLUSTERED
(
[AddressTypeID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
See Also
List of tables