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 | |
|---|---|---|---|---|---|---|---|---|
| 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 | |||
| IX_ForumGroups |
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