Tables [dbo].[am_link_virtswdef_edits]
Properties
PropertyValue
Row Count0
Created12:40:39 PM Sunday, December 05, 2010
Last Modified12:40:39 PM Sunday, December 05, 2010
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKam_link_sw_def: primary_sw_def_uuid\secondary_sw_def_uuidIndexes am_link_sw_def_idx1: secondary_sw_def_uuid\primary_sw_def_uuidsecondary_sw_def_uuidbinary(16)16
No
Cluster Primary Key XPKam_link_sw_def: primary_sw_def_uuid\secondary_sw_def_uuidIndexes am_link_sw_def_idx1: secondary_sw_def_uuid\primary_sw_def_uuidprimary_sw_def_uuidbinary(16)16
No
auto_rep_versiontimestamp8
Yes
last_update_dateint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKam_link_sw_def: primary_sw_def_uuid\secondary_sw_def_uuidXPKam_link_sw_defprimary_sw_def_uuid, secondary_sw_def_uuid
Yes
am_link_sw_def_idx1secondary_sw_def_uuid, primary_sw_def_uuid
Yes
Permissions
TypeActionOwning Principal
GrantDeleteca_itrm_group
GrantInsertca_itrm_group
GrantSelectca_itrm_group
GrantUpdateca_itrm_group
GrantSelectca_itrm_group_ams
SQL Script
CREATE TABLE [dbo].[am_link_virtswdef_edits]
(
[secondary_sw_def_uuid] [binary] (16) NOT NULL,
[primary_sw_def_uuid] [binary] (16) NOT NULL,
[auto_rep_version] [timestamp] NULL,
[last_update_date] [int] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[am_link_virtswdef_edits] ADD CONSTRAINT [XPKam_link_sw_def] PRIMARY KEY CLUSTERED ([primary_sw_def_uuid], [secondary_sw_def_uuid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [am_link_sw_def_idx1] ON [dbo].[am_link_virtswdef_edits] ([secondary_sw_def_uuid], [primary_sw_def_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[am_link_virtswdef_edits] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[am_link_virtswdef_edits] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[am_link_virtswdef_edits] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[am_link_virtswdef_edits] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[am_link_virtswdef_edits] TO [ca_itrm_group_ams]
GO
Uses