[aiowner].[ai_swdef_hwdef_rel

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	13843
Created	11:24:58 PM Monday, January 10, 2011
Last Modified	11:24:58 PM Monday, January 10, 2011

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Heap

Row Count

13843

Created

11:24:58 PM Monday, January 10, 2011

Last Modified

11:24:58 PM Monday, January 10, 2011

Name	Data Type	Max Length (Bytes)
source_domuuid_char	varchar(36)	36
source_swuuid_char	varchar(36)	36
source_hwuuid_char	varchar(36)	36
source_adomid	int	4
source_apid	int	4
source_udomid	int	4
source_unitid	int	4
source_domuuid	uniqueidentifier	16
source_swuuid	uniqueidentifier	16
source_hwuuid	uniqueidentifier	16
swuuid	uniqueidentifier	16
hwuuid	uniqueidentifier	16

Name

Data Type

Max Length (Bytes)

Allow Nulls

source_domuuid_char

varchar(36)

source_swuuid_char

varchar(36)

source_hwuuid_char

varchar(36)

source_adomid

int

source_apid

int

source_udomid

int

source_unitid

int

source_domuuid

uniqueidentifier

source_swuuid

uniqueidentifier

source_hwuuid

uniqueidentifier

swuuid

uniqueidentifier

hwuuid

uniqueidentifier

SQL Script

CREATE TABLE [aiowner].[ai_swdef_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,
[swuuid] [uniqueidentifier] NULL,
[hwuuid] [uniqueidentifier] NULL
) ON [PRIMARY]

GO