Tables [dbo].[ai_swcat_swdef_rel]
Properties
PropertyValue
Row Count54535
Created11:06:58 AM Wednesday, March 07, 2007
Last Modified11:10:02 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Primary Key ai_swcat_swdef_rel_pk: scuuid\swuuidCluster Key ai_swcat_swdef_rel_ak1: scuuidscuuiduniqueidentifier16
No
Primary Key ai_swcat_swdef_rel_pk: scuuid\swuuidIndexes ai_swcat_swdef_rel_ak2: swuuidswuuiduniqueidentifier16
No
Indexes Indexes
NameColumnsUnique
Primary Key ai_swcat_swdef_rel_pk: scuuid\swuuidai_swcat_swdef_rel_pkscuuid, swuuid
Yes
Cluster Key ai_swcat_swdef_rel_ak1: scuuidai_swcat_swdef_rel_ak1scuuid
ai_swcat_swdef_rel_ak2swuuid
Permissions
TypeActionOwning Principal
GrantDeleteaiadmin
GrantInsertaiadmin
GrantSelectaiadmin
GrantUpdateaiadmin
GrantSelectaipublic
SQL Script
CREATE TABLE [dbo].[ai_swcat_swdef_rel]
(
[scuuid] [uniqueidentifier] NOT NULL,
[swuuid] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_swcat_swdef_rel] ADD CONSTRAINT [ai_swcat_swdef_rel_pk] PRIMARY KEY NONCLUSTERED ([scuuid], [swuuid]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [ai_swcat_swdef_rel_ak1] ON [dbo].[ai_swcat_swdef_rel] ([scuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_swcat_swdef_rel_ak2] ON [dbo].[ai_swcat_swdef_rel] ([swuuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_swcat_swdef_rel] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_swcat_swdef_rel] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_swcat_swdef_rel] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_swcat_swdef_rel] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_swcat_swdef_rel] TO [aipublic]
GO
Uses
Used By