[cohesion].[cdnodessrvrtab_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
noderefr	datetime	8
refnoderefr	datetime	8
nodeid	int	4
refnodeid	int	4
nodename	varchar(90)	90
refnodename	varchar(90)	90
compchgcnt	int	4
filechgcnt	int	4
paramchgcnt	int	4
regchgcnt	int	4
confchgcnt	int	4
configdatachgcnt	int	4
mngdatachgcnt	int	4
nature	varchar(50)	50
rowkeyid	int	4

	Name	Columns	Unique
	PK__cdnodessrvrtab_u__65370702	rowkeyid

SQL Script

CREATE TABLE [cohesion].[cdnodessrvrtab_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,
[noderefr] [datetime] NULL,
[refnoderefr] [datetime] NULL,
[nodeid] [int] NULL,
[refnodeid] [int] NULL,
[nodename] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[refnodename] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[compchgcnt] [int] NULL,
[filechgcnt] [int] NULL,
[paramchgcnt] [int] NULL,
[regchgcnt] [int] NULL,
[confchgcnt] [int] NULL,
[configdatachgcnt] [int] NULL,
[mngdatachgcnt] [int] NULL,
[nature] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[rowkeyid] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cdnodessrvrtab_ui_table] ADD CONSTRAINT [PK__cdnodessrvrtab_u__65370702] PRIMARY KEY CLUSTERED ([rowkeyid]) ON [PRIMARY]
GO