Description
Types of addresses stored in the Address table.
Table properties
| name | value |
|---|
| name | [Person].[AddressType] |
| created | Mar 19 2009 9:09PM |
| modified | Mar 19 2009 9:10PM
|
| ansi nulls | on
|
| quoted identifier | on
|
| row count | 6 |
| Size of data | 8 kb |
| Size of indexes | 40 kb |
| Maximum size of a single row | 228 bytes |
Columns
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|
| AddressTypeID | int identity(1,1) | 10 | 4 | | no
| yes
| |
| no
| Primary key for AddressType records.
|
| Name | Name | 50 | 200 | | no
|
| |
| no
| Address type description. For example, Billing, Home, or Shipping.
|
| rowguid | uniqueidentifier | 36 | 16 | (newid()) | no
|
| |
| no
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| ModifiedDate | datetime | 23 | 8 | (getdate()) | no
|
| |
| no
| Date and time the record was last updated.
|
Indexes
| name | description | column | comment |
|---|
| AK_AddressType_Name | nonclustered, unique located on PRIMARY | Name | Unique nonclustered index.
|
| AK_AddressType_rowguid | nonclustered, unique located on PRIMARY | rowguid | Unique nonclustered index. Used to support replication samples.
|
| PK_AddressType_AddressTypeID | clustered, unique, primary key located on PRIMARY | AddressTypeID | Clustered index created by a primary key constraint.
|
Referenced by
Foreign key graph
Defaults
Dependency graph
Objects that [Person].[AddressType] depends on
| name | object type | database | server | level |
|---|
| Name | type | AdventureWorks2008 | SPRING\KATMAI | 1 |
Objects that depend on [Person].[AddressType]
Sample rows
| AddressTypeID | Name | rowguid | ModifiedDate |
|---|
| 1
| Billing
| b84f78b1-4efe-4a0e-8cb7-70e9f112f886
| 6/1/1998 12:00:00 AM
|
| 2
| Home
| 41bc2ff6-f0fc-475f-8eb9-cec0805aa0f2
| 6/1/1998 12:00:00 AM
|
| 3
| Main Office
| 8eeec28c-07a2-4fb9-ad0a-42d4a0bbc575
| 6/1/1998 12:00:00 AM
|
| 4
| Primary
| 24cb3088-4345-47c4-86c5-17b535133d1e
| 6/1/1998 12:00:00 AM
|
| 5
| Shipping
| b29da3f8-19a3-47da-9daa-15c84f4a83a5
| 6/1/1998 12:00:00 AM
|
| 6
| Archive
| a67f238a-5ba2-444b-966c-0467ed9c427f
| 6/1/1998 12:00:00 AM
|
Code
CREATE TABLE [Person].[AddressType](
[AddressTypeID] [int] IDENTITY(1,1) NOT NULL,
[Name] [dbo].[Name] NOT NULL,
[AddressTypeID] [int] IDENTITY(1,1) NOT NULL,
[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL,
[ModifiedDate] [datetime] NOT NULL,
CONSTRAINT [PK_AddressType_AddressTypeID] PRIMARY KEY CLUSTERED
(
[AddressTypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [Person].[AddressType] ADD CONSTRAINT [DF_AddressType_rowguid] DEFAULT (newid()) FOR [rowguid]
ALTER TABLE [Person].[AddressType] ADD CONSTRAINT [DF_AddressType_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]