[usmuser].[usm_install

[usmuser].[usm_install_r11]

(local) > mdb > Tables > usmuser.usm_install_r11

Properties
Columns
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	12
Created	9:33:28 PM Friday, April 10, 2009
Last Modified	9:33:28 PM Friday, April 10, 2009

Columns

Name	Data Type	Max Length (Bytes)
host_id	int	4
product_code	nvarchar(64)	128
name	nvarchar(128)	256
value	nvarchar(64)	128
data_type	tinyint	1

SQL Script

CREATE TABLE [usmuser].[usm_install_r11]
(
[host_id] [int] NOT NULL,
[product_code] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[name] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[value] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[data_type] [tinyint] NULL
) ON [PRIMARY]
GO

Uses

usmuser