Tables [cohesion].[cdnodesparmtab_ui_table]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count0
Created9:08:38 PM Wednesday, August 20, 2008
Last Modified9:08:38 PM Wednesday, August 20, 2008
Columns
NameData TypeMax Length (Bytes)Allow Nulls
difftextvarchar(40)40
Yes
changetextvarchar(40)40
Yes
descriptiontextmax
Yes
compnamevarchar(255)255
Yes
refcompnamevarchar(255)255
Yes
comprefrdatetime8
Yes
refcomprefrdatetime8
Yes
parcompnamevarchar(255)255
Yes
nodeidint4
Yes
refnodeidint4
Yes
compidint4
Yes
nodenamevarchar(90)90
Yes
refnodenamevarchar(90)90
Yes
compnameversionnestvarchar(255)255
Yes
categoryvarchar(50)50
Yes
valuetextmax
Yes
refvaluetextmax
Yes
foldervarchar(90)90
Yes
namevarchar(255)255
Yes
refnamevarchar(255)255
Yes
naturevarchar(90)90
Yes
Cluster Primary Key PK__cdnodesparmtab_u__6AEFE058: rowkeyidrowkeyidint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__cdnodesparmtab_u__6AEFE058: rowkeyidPK__cdnodesparmtab_u__6AEFE058rowkeyid
Yes
SQL Script
CREATE TABLE [cohesion].[cdnodesparmtab_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,
[value] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[refvalue] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[folder] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[refname] [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].[cdnodesparmtab_ui_table] ADD CONSTRAINT [PK__cdnodesparmtab_u__6AEFE058] PRIMARY KEY CLUSTERED ([rowkeyid]) ON [PRIMARY]
GO
Uses