Tables [dbo].[enterprise_package_status]
(local) > mdb > Tables > dbo.enterprise_package_status
Properties
PropertyValue
Row Count0
Created11:07:14 AM Wednesday, March 07, 2007
Last Modified11:09:38 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key $enter_u0000351f00000000: ep_idIndexes ndx_ent_package_status: ep_id\eccm_configurationidep_idint4
No
Indexes ndx_ent_package_status: ep_id\eccm_configurationideccm_configurationidint4
No
ep_pkgstatusint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key $enter_u0000351f00000000: ep_id$enter_u0000351f00000000ep_id
Yes
ndx_ent_package_statusep_id, eccm_configurationid
Permissions
TypeActionOwning Principal
GrantDeletecmew_admin
GrantInsertcmew_admin
GrantSelectcmew_admin
GrantUpdatecmew_admin
GrantSelectcmew_rdr
SQL Script
CREATE TABLE [dbo].[enterprise_package_status]
(
[ep_id] [int] NOT NULL,
[eccm_configurationid] [int] NOT NULL,
[ep_pkgstatus] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[enterprise_package_status] ADD CONSTRAINT [$enter_u0000351f00000000] PRIMARY KEY CLUSTERED ([ep_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ndx_ent_package_status] ON [dbo].[enterprise_package_status] ([ep_id], [eccm_configurationid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[enterprise_package_status] TO [cmew_admin]
GRANT INSERT ON  [dbo].[enterprise_package_status] TO [cmew_admin]
GRANT DELETE ON  [dbo].[enterprise_package_status] TO [cmew_admin]
GRANT UPDATE ON  [dbo].[enterprise_package_status] TO [cmew_admin]
GRANT SELECT ON  [dbo].[enterprise_package_status] TO [cmew_rdr]
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved