Tables [dbo].[EmailOptions]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)9
Created4:57:07 PM Thursday, September 7, 2006
Last Modified7:36:29 PM Tuesday, September 24, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_EmailOptions: EmailOptionsPriKeyEmailOptionsPriKeyint4
No
1 - 1
EmailOptionvarchar(50)50
Yes
Salessmallint2
Yes
Dispatchsmallint2
Yes
LogisticsCoorsmallint2
Yes
TransportationCoorsmallint2
Yes
Othersmallint2
Yes
OtherEmailvarchar(50)50
Yes
LDDispatchsmallint2
Yes
LDDriversmallint2
Yes
ProjectManagersmallint2
Yes
Indexes Indexes
NameColumnsUniqueFill Factor
Cluster Primary Key PK_EmailOptions: EmailOptionsPriKeyPK_EmailOptionsEmailOptionsPriKey
Yes
80
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[EmailOptions]
(
[EmailOptionsPriKey] [int] NOT NULL IDENTITY(1, 1),
[EmailOption] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Sales] [smallint] NULL,
[Dispatch] [smallint] NULL,
[LogisticsCoor] [smallint] NULL,
[TransportationCoor] [smallint] NULL,
[Other] [smallint] NULL,
[OtherEmail] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LDDispatch] [smallint] NULL,
[LDDriver] [smallint] NULL,
[ProjectManager] [smallint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[EmailOptions] ADD CONSTRAINT [PK_EmailOptions] PRIMARY KEY CLUSTERED  ([EmailOptionsPriKey]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[EmailOptions] TO [MssExec]
GRANT INSERT ON  [dbo].[EmailOptions] TO [MssExec]
GRANT DELETE ON  [dbo].[EmailOptions] TO [MssExec]
GRANT UPDATE ON  [dbo].[EmailOptions] TO [MssExec]
GO
Uses