Tables [dbo].[Forum_EmailQueue_TaskEmails]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count0
Created2:07:31 PM Saturday, November 06, 2010
Last Modified2:07:32 PM Saturday, November 06, 2010
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
EmailQueueIDint4
No
EmailAddressnvarchar(100)200
No
IsHTMLbit1
No
DisplayNamenvarchar(100)200
Yes
IsCompletebit1
No
((0))
DateAddeddatetime8
No
(getdate())
DateCompletedatetime8
Yes
Failedbit1
No
((0))
SQL Script
CREATE TABLE [dbo].[Forum_EmailQueue_TaskEmails]
(
[EmailQueueID] [int] NOT NULL,
[EmailAddress] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IsHTML] [bit] NOT NULL,
[DisplayName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsComplete] [bit] NOT NULL CONSTRAINT [DF__Forum_Ema__IsCom__45C948A1] DEFAULT ((0)),
[DateAdded] [datetime] NOT NULL CONSTRAINT [DF_Forum_EmailQueue_TaskEmails_DateAdded] DEFAULT (getdate()),
[DateComplete] [datetime] NULL,
[Failed] [bit] NOT NULL CONSTRAINT [DF_Forum_EmailQueue_TaskEmails_Failed] DEFAULT ((0))
) ON [PRIMARY]

GO
Uses
Used By