Tables [dbo].[arg_actiondf]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count17
Created12:30:43 PM Sunday, December 05, 2010
Last Modified10:34:31 PM Thursday, February 10, 2011
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key XPKarg_actiondf: adidadidint4
No
Indexes adindex02: adtext\adtype\ad1obtyadtextnvarchar(50)100
Yes
Indexes adindex02: adtext\adtype\ad1obtyad1obtysmallint2
Yes
adprotsmallint2
Yes
Indexes adindex02: adtext\adtype\ad1obtyadtypesmallint2
Yes
adsystemsmallint2
Yes
creation_usernvarchar(64)128
Yes
creation_dateint4
Yes
last_update_usernvarchar(64)128
Yes
last_update_dateint4
Yes
version_numberint4
Yes
('0')
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKarg_actiondf: adidXPKarg_actiondfadid
Yes
adindex02adtext, adtype, ad1obty
Yes
Permissions
TypeActionOwning Principal
GrantDeleteswcmadmin
GrantInsertswcmadmin
GrantSelectamsgroup
GrantSelectca_itrm_group
GrantSelectca_itrm_group_ams
GrantSelectswcmadmin
GrantUpdateswcmadmin
SQL Script
CREATE TABLE [dbo].[arg_actiondf]
(
[adid] [int] NOT NULL,
[adtext] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ad1obty] [smallint] NULL,
[adprot] [smallint] NULL,
[adtype] [smallint] NULL,
[adsystem] [smallint] NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__arg_actio__versi__589C25F3] DEFAULT ('0')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[arg_actiondf] ADD CONSTRAINT [XPKarg_actiondf] PRIMARY KEY CLUSTERED ([adid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [adindex02] ON [dbo].[arg_actiondf] ([adtext], [adtype], [ad1obty]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[arg_actiondf] TO [amsgroup]
GRANT SELECT ON  [dbo].[arg_actiondf] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[arg_actiondf] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[arg_actiondf] TO [swcmadmin]
GRANT INSERT ON  [dbo].[arg_actiondf] TO [swcmadmin]
GRANT DELETE ON  [dbo].[arg_actiondf] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[arg_actiondf] TO [swcmadmin]
GO
Uses
Used By