Tables [dbo].[AdminGL00100]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)1429
Created4:57:10 PM Thursday, September 7, 2006
Last Modified10:49:50 AM Thursday, April 21, 2011
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_AdminGL00100: PriKeyPriKeyint4
No
1 - 1
ACTNUMBR_1varchar(11)11
Yes
ACTNUMBR_2varchar(11)11
Yes
ACTNUMBR_3varchar(17)17
Yes
ACTNUMBR_4varchar(17)17
Yes
ACTNUMBR_5varchar(11)11
Yes
ACTDESCRvarchar(50)50
Yes
Indexes Indexes
NameColumnsUniqueFill Factor
Cluster Primary Key PK_AdminGL00100: PriKeyPK_AdminGL00100PriKey
Yes
80
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[AdminGL00100]
(
[PriKey] [int] NOT NULL IDENTITY(1, 1),
[ACTNUMBR_1] [varchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ACTNUMBR_2] [varchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ACTNUMBR_3] [varchar] (17) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ACTNUMBR_4] [varchar] (17) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ACTNUMBR_5] [varchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ACTDESCR] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AdminGL00100] ADD CONSTRAINT [PK_AdminGL00100] PRIMARY KEY CLUSTERED  ([PriKey]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[AdminGL00100] TO [MssExec]
GRANT INSERT ON  [dbo].[AdminGL00100] TO [MssExec]
GRANT DELETE ON  [dbo].[AdminGL00100] TO [MssExec]
GRANT UPDATE ON  [dbo].[AdminGL00100] TO [MssExec]
GO
Uses