[cohesion].[cdnodesfiletab_ui

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	9:08:38 PM Wednesday, August 20, 2008
Last Modified	9:08:38 PM Wednesday, August 20, 2008

Name	Data Type	Max Length (Bytes)
difftext	varchar(40)	40
changetext	varchar(40)	40
description	text	max
compname	varchar(255)	255
refcompname	varchar(255)	255
comprefr	datetime	8
refcomprefr	datetime	8
parcompname	varchar(255)	255
nodeid	int	4
refnodeid	int	4
compid	int	4
nodename	varchar(90)	90
refnodename	varchar(90)	90
compnameversionnest	varchar(255)	255
category	varchar(50)	50
cretimestamp	datetime	8
modtimestamp	datetime	8
owner	varchar(90)	90
permission	varchar(10)	10
filesize	int	4
refcretimestamp	datetime	8
refmodtimestamp	datetime	8
refowner	varchar(90)	90
refperm	varchar(10)	10
refsize	int	4
filetypeenum	varchar(90)	90
confchgcnt	int	4
filename	varchar(90)	90
dir	varchar(255)	255
nature	varchar(90)	90
rowkeyid	int	4

	Name	Columns	Unique
	PK__cdnodesfiletab_u__690797E6	rowkeyid

SQL Script

CREATE TABLE [cohesion].[cdnodesfiletab_ui_table]
(
[difftext] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[changetext] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[description] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[compname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[refcompname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[comprefr] [datetime] NULL,
[refcomprefr] [datetime] NULL,
[parcompname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[nodeid] [int] NULL,
[refnodeid] [int] NULL,
[compid] [int] NULL,
[nodename] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[refnodename] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[compnameversionnest] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[category] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cretimestamp] [datetime] NULL,
[modtimestamp] [datetime] NULL,
[owner] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[permission] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[filesize] [int] NULL,
[refcretimestamp] [datetime] NULL,
[refmodtimestamp] [datetime] NULL,
[refowner] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[refperm] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[refsize] [int] NULL,
[filetypeenum] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[confchgcnt] [int] NULL,
[filename] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dir] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[nature] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[rowkeyid] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cdnodesfiletab_ui_table] ADD CONSTRAINT [PK__cdnodesfiletab_u__690797E6] PRIMARY KEY CLUSTERED ([rowkeyid]) ON [PRIMARY]
GO