[dbo].[wsm_icon

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:08:02 AM Wednesday, March 07, 2007
Last Modified	11:10:02 AM Wednesday, March 07, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Row Count

Created

11:08:02 AM Wednesday, March 07, 2007

Last Modified

11:10:02 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
id	binary(16)	16
iconname	nvarchar(255)	510
icon_binary	image	max
icon_filename	nvarchar(512)	1024
status_id	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

Cluster Primary Key XPKwsm_icon_group: id

binary(16)

iconname

nvarchar(255)

510

icon_binary

image

max

icon_filename

nvarchar(512)

1024

status_id

int

	Name	Columns	Unique
	XPKwsm_icon_group	id
	xif1wsm_icon_group	status_id

Name

Columns

Unique

XPKwsm_icon_group

xif1wsm_icon_group

status_id

Name	Columns
r_128	status_id->[dbo].[wsm_status_definition].[status_id]

Name

Columns

r_128

status_id->[dbo].[wsm_status_definition].[status_id]

SQL Script

CREATE TABLE [dbo].[wsm_icon_group]
(
[id] [binary] (16) NOT NULL,
[iconname] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[icon_binary] [image] NULL,
[icon_filename] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[status_id] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsm_icon_group] ADD CONSTRAINT [XPKwsm_icon_group] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1wsm_icon_group] ON [dbo].[wsm_icon_group] ([status_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsm_icon_group] ADD CONSTRAINT [r_128] FOREIGN KEY ([status_id]) REFERENCES [dbo].[wsm_status_definition] ([status_id])
GO