Tables [aiowner].[ai_hfdef_hwdef_rel_s]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count10641
Created9:12:25 AM Thursday, November 06, 2008
Last Modified3:18:40 AM Wednesday, May 20, 2009
Columns
NameData TypeMax Length (Bytes)Allow Nulls
source_domuuid_charvarchar(36)36
Yes
source_swuuid_charvarchar(36)36
Yes
source_hwuuid_charvarchar(36)36
Yes
Indexes ai_hfdef_hwdef_rel_s_ak11: source_adomidsource_adomidint4
Yes
Indexes ai_hfdef_hwdef_rel_s_ak12: source_apidsource_apidint4
Yes
Indexes ai_hfdef_hwdef_rel_s_ak1: source_udomidsource_udomidint4
Yes
Indexes ai_hfdef_hwdef_rel_s_ak2: source_unitidsource_unitidint4
Yes
source_domuuiduniqueidentifier16
Yes
source_swuuiduniqueidentifier16
Yes
source_hwuuiduniqueidentifier16
Yes
hfuuiduniqueidentifier16
Yes
hwuuiduniqueidentifier16
Yes
Indexes Indexes
NameColumns
ai_hfdef_hwdef_rel_s_ak1source_udomid
ai_hfdef_hwdef_rel_s_ak11source_adomid
ai_hfdef_hwdef_rel_s_ak12source_apid
ai_hfdef_hwdef_rel_s_ak2source_unitid
SQL Script
CREATE TABLE [aiowner].[ai_hfdef_hwdef_rel_s]
(
[source_domuuid_char] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[source_swuuid_char] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[source_hwuuid_char] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[source_adomid] [int] NULL,
[source_apid] [int] NULL,
[source_udomid] [int] NULL,
[source_unitid] [int] NULL,
[source_domuuid] [uniqueidentifier] NULL,
[source_swuuid] [uniqueidentifier] NULL,
[source_hwuuid] [uniqueidentifier] NULL,
[hfuuid] [uniqueidentifier] NULL,
[hwuuid] [uniqueidentifier] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hfdef_hwdef_rel_s_ak11] ON [aiowner].[ai_hfdef_hwdef_rel_s] ([source_adomid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hfdef_hwdef_rel_s_ak12] ON [aiowner].[ai_hfdef_hwdef_rel_s] ([source_apid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hfdef_hwdef_rel_s_ak1] ON [aiowner].[ai_hfdef_hwdef_rel_s] ([source_udomid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hfdef_hwdef_rel_s_ak2] ON [aiowner].[ai_hfdef_hwdef_rel_s] ([source_unitid]) ON [PRIMARY]
GO
Uses