[dbo].[HARITEMNAME]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	54
Created	4:59:53 AM Monday, March 02, 2009
Last Modified	5:00:30 AM Monday, March 02, 2009

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Row Count

Created

4:59:53 AM Monday, March 02, 2009

Last Modified

5:00:30 AM Monday, March 02, 2009

	Name	Data Type	Max Length (Bytes)
$Indexes HARITEMNAME_ITEMNAMEUPPER: ITEMNAME\ITEMNAMEUPPER\NAMEOBJID$ $Indexes HARITEMNAME_ITEMNAME: ITEMNAME\NAMEOBJID$ $Indexes HARITEMNAME_OBJIDNAME: NAMEOBJID\ITEMNAME$	NAMEOBJID	int	4
$Indexes HARITEMNAME_ITEMNAMEUPPER: ITEMNAME\ITEMNAMEUPPER\NAMEOBJID$ $Indexes HARITEMNAME_ITEMNAME: ITEMNAME\NAMEOBJID$ $Indexes HARITEMNAME_OBJIDNAME: NAMEOBJID\ITEMNAME$	ITEMNAME	varchar(256)	256
$Indexes HARITEMNAME_ITEMNAMEUPPER: ITEMNAME\ITEMNAMEUPPER\NAMEOBJID$	ITEMNAMEUPPER	varchar(256)	256

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Indexes HARITEMNAME_ITEMNAMEUPPER: ITEMNAME\ITEMNAMEUPPER\NAMEOBJID$ $Indexes HARITEMNAME_ITEMNAME: ITEMNAME\NAMEOBJID$ $Indexes HARITEMNAME_OBJIDNAME: NAMEOBJID\ITEMNAME$

NAMEOBJID

int

$Indexes HARITEMNAME_ITEMNAMEUPPER: ITEMNAME\ITEMNAMEUPPER\NAMEOBJID$ $Indexes HARITEMNAME_ITEMNAME: ITEMNAME\NAMEOBJID$ $Indexes HARITEMNAME_OBJIDNAME: NAMEOBJID\ITEMNAME$

ITEMNAME

varchar(256)

256

$Indexes HARITEMNAME_ITEMNAMEUPPER: ITEMNAME\ITEMNAMEUPPER\NAMEOBJID$

ITEMNAMEUPPER

varchar(256)

256

	Name	Columns	Unique
	HARITEMNAME_PK	NAMEOBJID
	HARITEMNAME_ITEMNAME	ITEMNAME, NAMEOBJID
	HARITEMNAME_ITEMNAMEUPPER	ITEMNAME, ITEMNAMEUPPER, NAMEOBJID
	HARITEMNAME_OBJIDNAME	NAMEOBJID, ITEMNAME

Name

Columns

Unique

HARITEMNAME_PK

NAMEOBJID

HARITEMNAME_ITEMNAME

ITEMNAME, NAMEOBJID

HARITEMNAME_ITEMNAMEUPPER

ITEMNAME, ITEMNAMEUPPER, NAMEOBJID

HARITEMNAME_OBJIDNAME

NAMEOBJID, ITEMNAME

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARITEMNAME table stores the definition of an object of an item.
Caption	COLUMN	ITEMNAME	Name of item
Caption	COLUMN	ITEMNAMEUPPER	Name of item in uppercase characters
Caption	COLUMN	NAMEOBJID	Object ID of item name

Name

Level 2 Type

Level 2 Name

Value

Caption

The HARITEMNAME table stores the definition of an object of an item.

Caption

COLUMN

ITEMNAME

Name of item

Caption

COLUMN

ITEMNAMEUPPER

Name of item in uppercase characters

Caption

COLUMN

NAMEOBJID

Object ID of item name

SQL Script

CREATE TABLE [dbo].[HARITEMNAME]
(
[NAMEOBJID] [int] NOT NULL,
[ITEMNAME] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[ITEMNAMEUPPER] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARITEMNAME] ADD CONSTRAINT [HARITEMNAME_PK] PRIMARY KEY CLUSTERED ([NAMEOBJID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARITEMNAME_ITEMNAMEUPPER] ON [dbo].[HARITEMNAME] ([ITEMNAMEUPPER], [NAMEOBJID]) INCLUDE ([ITEMNAME]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARITEMNAME_ITEMNAME] ON [dbo].[HARITEMNAME] ([ITEMNAME], [NAMEOBJID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARITEMNAME_OBJIDNAME] ON [dbo].[HARITEMNAME] ([NAMEOBJID], [ITEMNAME]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'Caption', N'The HARITEMNAME table stores the definition of an object of an item. ', 'SCHEMA', N'dbo', 'TABLE', N'HARITEMNAME', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Name of item', 'SCHEMA', N'dbo', 'TABLE', N'HARITEMNAME', 'COLUMN', N'ITEMNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of item in uppercase characters', 'SCHEMA', N'dbo', 'TABLE', N'HARITEMNAME', 'COLUMN', N'ITEMNAMEUPPER'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of item name', 'SCHEMA', N'dbo', 'TABLE', N'HARITEMNAME', 'COLUMN', N'NAMEOBJID'
GO