[dbo].[C2OConfigComponents]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	11:43:57 AM Friday, March 26, 2010
Last Modified	11:43:57 AM Friday, March 26, 2010

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

11:43:57 AM Friday, March 26, 2010

Last Modified

11:43:57 AM Friday, March 26, 2010

	Name	Data Type	Max Length (Bytes)	Default
	NodeName	varchar(255)	255
$Cluster Primary Key PK__C2OConfigCompone__7B5B524B: HostID\NodeID$	NodeID	varchar(255)	255	('')
$Cluster Primary Key PK__C2OConfigCompone__7B5B524B: HostID\NodeID$	HostID	varchar(255)	255	('')
	EnvironmentName	varchar(255)	255
	DomainName	varchar(255)	255
	ObjectType	varchar(45)	45

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

NodeName

varchar(255)

255

$Cluster Primary Key PK__C2OConfigCompone__7B5B524B: HostID\NodeID$

NodeID

varchar(255)

255

('')

$Cluster Primary Key PK__C2OConfigCompone__7B5B524B: HostID\NodeID$

HostID

varchar(255)

255

('')

EnvironmentName

varchar(255)

255

DomainName

varchar(255)

255

ObjectType

varchar(45)

	Name	Columns	Unique
$Cluster Primary Key PK__C2OConfigCompone__7B5B524B: HostID\NodeID$	PK__C2OConfigCompone__7B5B524B	HostID, NodeID

Name

Columns

Unique

$Cluster Primary Key PK__C2OConfigCompone__7B5B524B: HostID\NodeID$

PK__C2OConfigCompone__7B5B524B

HostID, NodeID

SQL Script

CREATE TABLE [dbo].[C2OConfigComponents]
(
[NodeName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NodeID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__C2OConfig__NodeI__797309D9] DEFAULT (''),
[HostID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__C2OConfig__HostI__7A672E12] DEFAULT (''),
[EnvironmentName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DomainName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ObjectType] [varchar] (45) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[C2OConfigComponents] ADD CONSTRAINT [PK__C2OConfigCompone__7B5B524B] PRIMARY KEY CLUSTERED ([HostID], [NodeID]) ON [PRIMARY]
GO