View Properties

Name	Value
Owner	dbo
Created	2004-05-31

Columns

Name	Data Type	Length
AIM	nvarchar	50
Approved	bit	1
Attributes	binary	4
AvatarType	int	4
AvatarUrl	nvarchar	256
DateCreated	datetime	8
DateFormat	nvarchar	10
Email	nvarchar	75
FakeEmail	nvarchar	75
FlatView	bit	1
ForumView	int	4
HasAvatar	bit	1
ICQ	nvarchar	50
Interests	nvarchar	100
IsModerator	int	4
LastActivity	datetime	8
LastLogin	datetime	8
Location	nvarchar	100
MSN	nvarchar	50
Occupation	nvarchar	100
Password	nvarchar	50
PostViewOrder	bit	1
ProfileApproved	bit	1
ShowAvatar	bit	1
ShowUnreadTopicsOnly	bit	1
Signature	nvarchar	256
Style	nvarchar	20
TimeZone	int	4
TotalPosts	int	4
TrackYourPosts	bit	1
Trusted	bit	1
URL	nvarchar	100
UserName	nvarchar	50
Yahoo	nvarchar	50

Total: 34 column(s)

SQL

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


CREATE VIEW forums_User
AS
    SELECT
        UserName,
        Password, 
        Email, 
        ForumView, 
        Approved, 
        ProfileApproved, 
        Trusted, 
        FakeEmail, 
        URL, 
        Signature, 
        DateCreated, 
        TrackYourPosts, 
        LastLogin, 
        LastActivity, 
        TimeZone, 
        Location, 
        Occupation, 
        Interests, 
        MSN, 
        Yahoo, 
        AIM, 
        ICQ, 
        TotalPosts, 
        HasAvatar, 
        ShowUnreadTopicsOnly, 
        Style, 
        AvatarType, 
        ShowAvatar, 
        DateFormat, 
        PostViewOrder,
        AvatarUrl,
        (
            SELECT COUNT(*)
            FROM Moderators
            WHERE Moderators.Username = Users.Username
        ) AS IsModerator,
        FlatView,
        Attributes
    FROM Users

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO