View Properties

Name	Value
Owner	dbo
Created	2004-05-31

Columns

Name	Data Type	Length
Active	bit	1
DateCreated	datetime	8
DaysToView	int	4
Description	nvarchar	3000
DisplayMask	binary	64
ForumGroupId	int	4
ForumID	int	4
Moderated	bit	1
MostRecentPostAuthor	nvarchar	50
MostRecentPostDate	datetime	8
MostRecentPostID	int	4
MostRecentThreadID	int	4
Name	nvarchar	100
ParentID	int	4
SortOrder	int	4
TotalPosts	int	4
TotalTopics	int	4

Total: 17 column(s)

SQL

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


CREATE VIEW forums_Forum
AS
    SELECT
        ForumID,
        ForumGroupId, 
        ParentID, 
        Name, 
        Description, 
        DateCreated, 
        DaysToView, 
        Moderated, 
        TotalPosts, 
        TotalThreads AS TotalTopics,
        MostRecentPostID, 
        MostRecentThreadID, 
        MostRecentPostDate, 
        MostRecentPostAuthor, 
        Active,
        SortOrder, 
        DisplayMask
    FROM
        Forums

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO