Tables [dbo].[statmodm]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count0
Created11:07:32 AM Wednesday, March 07, 2007
Last Modified11:09:13 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKstatmodm: object_uuid\mdomid\moid\statpartobject_uuidbinary(16)16
No
object_typeint4
Yes
object_domain_uuidbinary(16)16
Yes
Cluster Primary Key XPKstatmodm: object_uuid\mdomid\moid\statpartmdomidint4
No
Cluster Primary Key XPKstatmodm: object_uuid\mdomid\moid\statpartmoidint4
No
Cluster Primary Key XPKstatmodm: object_uuid\mdomid\moid\statpartstatpartint4
No
stattextntextmax
Yes
auto_rep_versiontimestamp8
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKstatmodm: object_uuid\mdomid\moid\statpartXPKstatmodmobject_uuid, mdomid, moid, statpart
Yes
Permissions
TypeActionOwning Principal
GrantDeleteca_itrm_group
GrantInsertca_itrm_group
GrantSelectca_itrm_group
GrantUpdateca_itrm_group
GrantSelectupmuser_group
GrantSelectca_itrm_group_ams
GrantSelectams_group
SQL Script
CREATE TABLE [dbo].[statmodm]
(
[object_uuid] [binary] (16) NOT NULL,
[object_type] [int] NULL,
[object_domain_uuid] [binary] (16) NULL,
[mdomid] [int] NOT NULL,
[moid] [int] NOT NULL,
[statpart] [int] NOT NULL,
[stattext] [ntext] COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[auto_rep_version] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[statmodm] ADD CONSTRAINT [XPKstatmodm] PRIMARY KEY CLUSTERED ([object_uuid], [mdomid], [moid], [statpart]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[statmodm] TO [ams_group]
GRANT SELECT ON  [dbo].[statmodm] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[statmodm] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[statmodm] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[statmodm] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[statmodm] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[statmodm] TO [upmuser_group]
GO
Uses
Used By