[dbo].[StaticContent]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	12:44:45 PM Thursday, October 04, 2007
Last Modified	12:44:45 PM Thursday, October 04, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

12:44:45 PM Thursday, October 04, 2007

Last Modified

12:44:45 PM Thursday, October 04, 2007

Name	Data Type	Max Length (Bytes)	Identity
itemID	int	4	1 - 1
divisionID	int	4
GUID	nvarchar(255)	510
itemName	nvarchar(255)	510
itemDesc	nvarchar(255)	510
itemMimeType	nvarchar(50)	100
version	int	4
isLocked	int	4
itemContents	image	max

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

itemID

int

1 - 1

divisionID

int

GUID

nvarchar(255)

510

itemName

nvarchar(255)

510

itemDesc

nvarchar(255)

510

itemMimeType

nvarchar(50)

100

version

int

isLocked

int

itemContents

image

max

	Name	Columns	Unique
	PK__StaticContent__0A9D95DB	itemID

Name

Columns

Unique

PK__StaticContent__0A9D95DB

itemID

SQL Script

CREATE TABLE [dbo].[StaticContent]
(
[itemID] [int] NOT NULL IDENTITY(1, 1),
[divisionID] [int] NOT NULL,
[GUID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[itemName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[itemDesc] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[itemMimeType] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[version] [int] NULL,
[isLocked] [int] NULL,
[itemContents] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[StaticContent] ADD CONSTRAINT [PK__StaticContent__0A9D95DB] PRIMARY KEY CLUSTERED ([itemID]) ON [PRIMARY]
GO