[cohesion].[servicecomponents_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:39 PM Wednesday, August 20, 2008

Name	Data Type	Max Length (Bytes)
module_id	int	4
mod_name	varchar(90)	90
mod_mgmt_type	varchar(50)	50
module_category	varchar(50)	50
creation_time	datetime	8
networks	varchar(255)	255
osname	varchar(50)	50
mod_qualifier	varchar(255)	255
svrgrps	varchar(4000)	4000
host_id	int	4
host_name	varchar(90)	90
istop	varchar(20)	20
services	varchar(4000)	4000
mod_version	varchar(40)	40

	Name	Columns	Unique
	PK__servicecomponent__634EBE90	module_id

SQL Script

CREATE TABLE [cohesion].[servicecomponents_ui_table]
(
[module_id] [int] NOT NULL,
[mod_name] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mod_mgmt_type] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[module_category] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_time] [datetime] NULL,
[networks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[osname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mod_qualifier] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[svrgrps] [varchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[host_id] [int] NULL,
[host_name] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[istop] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[services] [varchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mod_version] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[servicecomponents_ui_table] ADD CONSTRAINT [PK__servicecomponent__634EBE90] PRIMARY KEY CLUSTERED ([module_id]) ON [PRIMARY]
GO