Table Icon dbo.ForumsRead

Table Properties

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

Columns

  Name Description Data Type Length NULL Default RowGUIDCOL Computed
  ForumId int 4      
  Username nvarchar 50      
  MarkReadAfter int 4      
  LastActivity datetime 8      

Total: 4 column(s)

Indentity Column

No identity column exists

Check Constraints

No check constraints exists

Indexes

Index Primary Unique Clustered
IX_ForumsReadByDate      
IX_ForumsReadByDate_1      

Permissions

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

SQL

CREATE TABLE [ForumsRead] (
	[ForumId] [int] NOT NULL ,
	[Username] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[MarkReadAfter] [int] NOT NULL CONSTRAINT [DF_ForumsReadByDate_MarkReadAfter] DEFAULT (0),
	[LastActivity] [datetime] NOT NULL CONSTRAINT [DF_ForumsRead_LastActivity] DEFAULT (getdate())
) ON [PRIMARY]
GO



					

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