Table Properties

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

Columns

	Name	Description	Data Type	Length	NULL	Default	RowGUIDCOL	Computed
	PostID		int	4
	ThreadID		int	4
	ParentID		int	4
	PostLevel		int	4
	SortOrder		int	4
	Subject		nvarchar	256
	PostDate		datetime	8
	Approved		bit	1
	ForumID		int	4
	UserName		nvarchar	50
	ThreadDate		datetime	8
	TotalViews		int	4
	IsLocked		bit	1
	IsPinned		bit	1
	PinnedDate		datetime	8
	Body		ntext	16

Total: 16 column(s)

Indentity Column

Name	Seed	Increment	Not for Replication
PostID	1	1

Check Constraints

No check constraints exists

Indexes

Index	Primary	Unique	Clustered

Permissions

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

SQL

CREATE TABLE [Post_Archive] (
	[PostID] [int] IDENTITY (1, 1) NOT NULL ,
	[ThreadID] [int] NOT NULL ,
	[ParentID] [int] NOT NULL ,
	[PostLevel] [int] NOT NULL ,
	[SortOrder] [int] NOT NULL ,
	[Subject] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[PostDate] [datetime] NOT NULL ,
	[Approved] [bit] NOT NULL ,
	[ForumID] [int] NOT NULL ,
	[UserName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ThreadDate] [datetime] NOT NULL ,
	[TotalViews] [int] NOT NULL ,
	[IsLocked] [bit] NOT NULL ,
	[IsPinned] [bit] NOT NULL ,
	[PinnedDate] [datetime] NOT NULL ,
	[Body] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO