[usmuser].[usm_install_r12

[usmuser].[usm_install_r12_0]

(local) > mdb > Tables > usmuser.usm_install_r12_0

Properties
Columns
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	26
Created	11:17:27 AM Tuesday, March 30, 2010
Last Modified	11:17:27 AM Tuesday, March 30, 2010

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_r12_0]
(
[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