[dbo].[investigation

[dbo].[investigation_history]

(local) > mdb > Tables > dbo.investigation_history

Properties
Columns
SQL Script
Uses
Used By

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	0
Created	12:31:02 PM Sunday, December 05, 2010
Last Modified	12:31:02 PM Sunday, December 05, 2010

Columns

Name	Data Type	Max Length (Bytes)
investigation_name	varchar(32)	32
timestamp	datetime	8
administrator	varchar(32)	32
note_text	varchar(1536)	1536

SQL Script

CREATE TABLE [dbo].[investigation_history]
(
[investigation_name] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[timestamp] [datetime] NULL,
[administrator] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[note_text] [varchar] (1536) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]

GO

Uses

Used By

[dbo].[investigationhistoryview]