[dbo].[Addresses]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	11
Created	12:44:45 PM Thursday, October 04, 2007
Last Modified	12:44:45 PM Thursday, October 04, 2007

Name	Data Type	Max Length (Bytes)	Identity
addrID	int	4	1 - 1
address1	nvarchar(100)	200
address2	nvarchar(100)	200
address3	nvarchar(100)	200
city	nvarchar(100)	200
state	nvarchar(100)	200
country	nvarchar(100)	200
zip	nvarchar(10)	20
phone	nvarchar(100)	200
email	nvarchar(300)	600

	Name	Columns	Unique
	pk_addresses	addrID

SQL Script

CREATE TABLE [dbo].[Addresses]
(
[addrID] [int] NOT NULL IDENTITY(1, 1),
[address1] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[address2] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[address3] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[city] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[state] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[country] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[zip] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[phone] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[email] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Addresses] ADD CONSTRAINT [pk_addresses] PRIMARY KEY CLUSTERED ([addrID]) ON [PRIMARY]
GO