Tables [dbo].[ai_dom_ds_rel]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count1
Created9:04:10 AM Thursday, November 06, 2008
Last Modified9:04:10 AM Thursday, November 06, 2008
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Primary Key PK_ai_dom_ds_rel: domuuid\dssourceuuidIndexes IX_ai_dom_ds_rel_1: domuuiddomuuiduniqueidentifier16
No
Primary Key PK_ai_dom_ds_rel: domuuid\dssourceuuidIndexes IX_ai_dom_ds_rel_2: dssourceuuiddssourceuuiduniqueidentifier16
No
domain_labelnvarchar(128)256
Yes
Indexes Indexes
NameColumnsUnique
Primary Key PK_ai_dom_ds_rel: domuuid\dssourceuuidPK_ai_dom_ds_reldomuuid, dssourceuuid
Yes
IX_ai_dom_ds_rel_1domuuid
IX_ai_dom_ds_rel_2dssourceuuid
Permissions
TypeActionOwning Principal
GrantDeleteaiadmin
GrantInsertaiadmin
GrantReferencesaiadmin
GrantSelectaiadmin
GrantUpdateaiadmin
GrantSelectaipublic
SQL Script
CREATE TABLE [dbo].[ai_dom_ds_rel]
(
[domuuid] [uniqueidentifier] NOT NULL,
[dssourceuuid] [uniqueidentifier] NOT NULL,
[domain_label] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_dom_ds_rel] ADD CONSTRAINT [PK_ai_dom_ds_rel] PRIMARY KEY NONCLUSTERED ([domuuid], [dssourceuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ai_dom_ds_rel_1] ON [dbo].[ai_dom_ds_rel] ([domuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ai_dom_ds_rel_2] ON [dbo].[ai_dom_ds_rel] ([dssourceuuid]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[ai_dom_ds_rel] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_dom_ds_rel] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_dom_ds_rel] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_dom_ds_rel] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_dom_ds_rel] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_dom_ds_rel] TO [aipublic]
GO
Uses