Tables [dbo].[arg_link_notification_attachmt]
Properties
PropertyValue
Row Count0
Created11:13:54 AM Wednesday, March 07, 2007
Last Modified11:13:54 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK__arg_link_notific__4C4DBFAC: object_uuid\amid\nyerid\nyidobject_uuidbinary(16)16
No
Cluster Primary Key PK__arg_link_notific__4C4DBFAC: object_uuid\amid\nyerid\nyidamidint4
No
Cluster Primary Key PK__arg_link_notific__4C4DBFAC: object_uuid\amid\nyerid\nyidnyeridint4
No
Cluster Primary Key PK__arg_link_notific__4C4DBFAC: object_uuid\amid\nyerid\nyidnyidsmallint2
No
last_update_dateint4
Yes
version_numberint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__arg_link_notific__4C4DBFAC: object_uuid\amid\nyerid\nyidPK__arg_link_notific__4C4DBFACobject_uuid, amid, nyerid, nyid
Yes
Permissions
TypeActionOwning Principal
GrantSelectuapmadmin_group
GrantSelectuapmbatch_group
GrantSelectuapmreporting_group
GrantSelectuapmadmin
GrantSelectuapmbatch
GrantSelectuapmreporting
GrantSelectswcmadmin
SQL Script
CREATE TABLE [dbo].[arg_link_notification_attachmt]
(
[object_uuid] [binary] (16) NOT NULL,
[amid] [int] NOT NULL,
[nyerid] [int] NOT NULL,
[nyid] [smallint] NOT NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_link_notification_attachmt] ADD CONSTRAINT [PK__arg_link_notific__4C4DBFAC] PRIMARY KEY CLUSTERED ([object_uuid], [amid], [nyerid], [nyid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[arg_link_notification_attachmt] TO [swcmadmin]
GRANT SELECT ON  [dbo].[arg_link_notification_attachmt] TO [uapmadmin]
GRANT SELECT ON  [dbo].[arg_link_notification_attachmt] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[arg_link_notification_attachmt] TO [uapmbatch]
GRANT SELECT ON  [dbo].[arg_link_notification_attachmt] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[arg_link_notification_attachmt] TO [uapmreporting]
GRANT SELECT ON  [dbo].[arg_link_notification_attachmt] TO [uapmreporting_group]
GO
Uses