[dbo].[REG_CONTENT

[dbo].[REG_CONTENT_INDEX]

(local) > catalystdb > Tables > dbo.REG_CONTENT_INDEX

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	1:08:01 AM Thursday, September 10, 2009
Last Modified	1:08:01 AM Thursday, September 10, 2009

Columns

Name	Data Type	Max Length (Bytes)
name_	varchar(50)	50
value_	image	max
size_	int	4
lf_	datetime	8
deleted_	tinyint	1

Indexes

	Name	Columns	Unique
	PK__REG_CONTENT_INDE__534D60F1	name_

SQL Script

CREATE TABLE [dbo].[REG_CONTENT_INDEX]
(
[name_] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[value_] [image] NULL,
[size_] [int] NULL,
[lf_] [datetime] NULL,
[deleted_] [tinyint] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[REG_CONTENT_INDEX] ADD CONSTRAINT [PK__REG_CONTENT_INDE__534D60F1] PRIMARY KEY CLUSTERED ([name_]) ON [PRIMARY]
GO

Uses