[cohesion].[cdnodescomptab_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
filechgcnt	int	4
paramchgcnt	int	4
regchgcnt	int	4
confchgcnt	int	4
configdatachgcnt	int	4
mngdatachgcnt	int	4
compcategoryenum	varchar(90)	90
nature	varchar(50)	50
rowkeyid	int	4

	Name	Columns	Unique
	PK__cdnodescomptab_u__671F4F74	rowkeyid

SQL Script

CREATE TABLE [cohesion].[cdnodescomptab_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,
[filechgcnt] [int] NULL,
[paramchgcnt] [int] NULL,
[regchgcnt] [int] NULL,
[confchgcnt] [int] NULL,
[configdatachgcnt] [int] NULL,
[mngdatachgcnt] [int] NULL,
[compcategoryenum] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS 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].[cdnodescomptab_ui_table] ADD CONSTRAINT [PK__cdnodescomptab_u__671F4F74] PRIMARY KEY CLUSTERED ([rowkeyid]) ON [PRIMARY]
GO