[dbo].[document]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	78
Created	4:53:07 PM Sunday, February 07, 2010
Last Modified	4:53:07 PM Sunday, February 07, 2010

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

4:53:07 PM Sunday, February 07, 2010

Last Modified

4:53:07 PM Sunday, February 07, 2010

Name	Data Type	Max Length (Bytes)
doc_id	varchar(40)	40
doc_name	nvarchar(256)	512
doc_type	nvarchar(64)	128
create_date	datetime	8
remove_date	datetime	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

doc_id

varchar(40)

doc_name

nvarchar(256)

512

doc_type

nvarchar(64)

128

create_date

datetime

remove_date

datetime

	Name	Columns	Unique
	PK_document	doc_id
	IX_document_removeDate	remove_date

Name

Columns

Unique

PK_document

doc_id

IX_document_removeDate

remove_date

SQL Script

CREATE TABLE [dbo].[document]
(
[doc_id] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[doc_name] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[doc_type] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[create_date] [datetime] NULL,
[remove_date] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[document] ADD CONSTRAINT [PK_document] PRIMARY KEY CLUSTERED ([doc_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_document_removeDate] ON [dbo].[document] ([remove_date]) ON [PRIMARY]
GO