Table Icon dbo.forums_Forum

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


					

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