[ca_itrm].[R000015

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	22
Created	4:48:14 PM Monday, December 07, 2009
Last Modified	4:48:14 PM Monday, December 07, 2009

Name	Data Type	Max Length (Bytes)	Default
IDX	int	4
COLNAME	nvarchar(127)	254	('')
ITEMNAME	nvarchar(127)	254	('')
ITEMINFO	ntext	max
TYPE	int	4

	Name	Columns	Unique
	R000015_M_pk	IDX

SQL Script

CREATE TABLE [ca_itrm].[R000015_M]
(
[IDX] [int] NOT NULL,
[COLNAME] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__R000015_M__COLNA__3FF23C32] DEFAULT (''),
[ITEMNAME] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__R000015_M__ITEMN__40E6606B] DEFAULT (''),
[ITEMINFO] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TYPE] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [ca_itrm].[R000015_M] ADD CONSTRAINT [R000015_M_pk] PRIMARY KEY CLUSTERED ([IDX]) ON [PRIMARY]
GO