Table Icon dbo.ForumGroups

Table Properties

Name Value
Owner dbo
Created 2004-05-31
Located On PRIMARY
Rows 1
Data Size KB 8
Index Size KB 32

Columns

  Name Description Data Type Length NULL Default RowGUIDCOL Computed
Primary KeyIdentity ForumGroupId int 4      
  Name nvarchar 256      
  SortOrder int 4      

Total: 3 column(s)

Indentity Column

Name Seed Increment Not for Replication
ForumGroupId 1 1  

Check Constraints

No check constraints exists

Indexes

Index Primary Unique Clustered
PK_ForumGroup Primary Key Unique Index Clustered Index
IX_ForumGroups   Unique Index  

Permissions

No direct permissions defined (N.B. Permissions may be inherited from roles

SQL

CREATE TABLE [ForumGroups] (
	[ForumGroupId] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[SortOrder] [int] NOT NULL CONSTRAINT [DF__ForumGrou__SortO__25518C17] DEFAULT (0),
	CONSTRAINT [PK_ForumGroup] PRIMARY KEY  CLUSTERED 
	(
		[ForumGroupId]
	)  ON [PRIMARY] ,
	CONSTRAINT [IX_ForumGroups] UNIQUE  NONCLUSTERED 
	(
		[Name]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO



					

Generated on 26/08/2004 15:05:22 by DataAide.