Table Properties

Name	Value
Owner	dbo
Created	2004-05-31
Located On	PRIMARY
Rows	9
Data Size KB	24
Index Size KB	16

Columns

	Name	Description	Data Type	Length	NULL	Default	RowGUIDCOL	Computed
	EmailID		int	4
	Subject		nvarchar	128
	Importance		int	4
	FromAddress		nvarchar	75
	Description		nvarchar	200
	Message		ntext	16

Total: 6 column(s)

Indentity Column

Name	Seed	Increment	Not for Replication
EmailID	1	1

Check Constraints

No check constraints exists

Indexes

Index	Primary	Unique	Clustered
PK_Emails

Permissions

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

SQL

CREATE TABLE [Emails] (
	[EmailID] [int] IDENTITY (1, 1) NOT NULL ,
	[Subject] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Importance] [int] NOT NULL CONSTRAINT [DF_Emails_Importance] DEFAULT (1),
	[FromAddress] [nvarchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Description] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Emails_Description] DEFAULT (''),
	[Message] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__Emails__Message2__7CD98669] DEFAULT (''),
	CONSTRAINT [PK_Emails] PRIMARY KEY  CLUSTERED 
	(
		[EmailID]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO