Tables [cohesion].[cdnodesconftab_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
parsevarchar(90)90
Yes
valuetextmax
Yes
refvaluetextmax
Yes
namevarchar(255)255
Yes
filenamevarchar(90)90
Yes
dirvarchar(255)255
Yes
naturevarchar(90)90
Yes
Cluster Primary Key PK__cdnodesconftab_u__6CD828CA: rowkeyidrowkeyidint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__cdnodesconftab_u__6CD828CA: rowkeyidPK__cdnodesconftab_u__6CD828CArowkeyid
Yes
SQL Script
CREATE TABLE [cohesion].[cdnodesconftab_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,
[parse] [varchar] (90) 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,
[name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS 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].[cdnodesconftab_ui_table] ADD CONSTRAINT [PK__cdnodesconftab_u__6CD828CA] PRIMARY KEY CLUSTERED ([rowkeyid]) ON [PRIMARY]
GO
Uses