Tables [dbo].[SecModules]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)66
Created4:57:08 PM Thursday, September 7, 2006
Last Modified7:31:15 PM Thursday, August 29, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_SecModules: ModulePriKeyModulePriKeyint4
No
1 - 1
Indexes IX_SecModules_Active: Active\DescriptionIndexes IX_SecModules_Description: Active\DescriptionDescriptionvarchar(30)30
No
Indexes IX_SecModules_Active: Active\DescriptionIndexes IX_SecModules_Description: Active\DescriptionActivesmallint2
Yes
Indexes Indexes
NameColumnsUniqueFill Factor
Cluster Primary Key PK_SecModules: ModulePriKeyPK_SecModulesModulePriKey
Yes
80
IX_SecModules_ActiveActive, Description
Yes
IX_SecModules_DescriptionActive, Description
Yes
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[SecModules]
(
[ModulePriKey] [int] NOT NULL IDENTITY(1, 1),
[Description] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Active] [smallint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SecModules] ADD CONSTRAINT [PK_SecModules] PRIMARY KEY CLUSTERED  ([ModulePriKey]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_SecModules_Active] ON [dbo].[SecModules] ([Active], [Description]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_SecModules_Description] ON [dbo].[SecModules] ([Description]) INCLUDE ([Active]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[SecModules] TO [MssExec]
GRANT INSERT ON  [dbo].[SecModules] TO [MssExec]
GRANT DELETE ON  [dbo].[SecModules] TO [MssExec]
GRANT UPDATE ON  [dbo].[SecModules] TO [MssExec]
GO
Uses
Used By