[dbo].[Forum_Keywords]

(local) > DotNetNuke_Community > Tables > dbo.Forum_Keywords

Properties
Columns
Indexes
SQL Script
Uses
Used By

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	32
Created	2:07:31 PM Saturday, November 06, 2010
Last Modified	2:07:31 PM Saturday, November 06, 2010

Columns

Name	Data Type	Max Length (Bytes)	Identity
KeywordID	int	4	1 - 1
Token	nvarchar(50)	100
Description	nvarchar(200)	400
ContentTypeID	int	4

Indexes

	Name	Columns	Unique
	dbo.PK_Forum_Keywords	KeywordID

SQL Script

CREATE TABLE [dbo].[Forum_Keywords]
(
[KeywordID] [int] NOT NULL IDENTITY(1, 1),
[Token] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContentTypeID] [int] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Forum_Keywords] ADD CONSTRAINT [dbo.PK_Forum_Keywords] PRIMARY KEY CLUSTERED ([KeywordID]) ON [PRIMARY]
GO

Uses

Used By

[dbo].[Forum_KeywordsByTypeGet]