[aiowner].[ai_hwdef_prop_hwproc

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	133
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

133

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_set_priority	int	4
source_domuuid_char	varchar(36)	36
source_hwuuid_char	varchar(36)	36
source_domain_id	int	4
source_unit_id	int	4
domuuid	uniqueidentifier	16
hwuuid	uniqueidentifier	16
hwprocmfgr	nvarchar(128)	256
hwprocmodel	nvarchar(128)	256
hwproctype	nvarchar(128)	256
hwprocspeed	int	4
hwprocid	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

source_set_priority

int

source_domuuid_char

varchar(36)

source_hwuuid_char

varchar(36)

source_domain_id

int

source_unit_id

int

domuuid

uniqueidentifier

hwuuid

uniqueidentifier

hwprocmfgr

nvarchar(128)

256

hwprocmodel

nvarchar(128)

256

hwproctype

nvarchar(128)

256

hwprocspeed

int

hwprocid

int

SQL Script

CREATE TABLE [aiowner].[ai_hwdef_prop_hwproc_s]
(
[source_set_priority] [int] NOT NULL,
[source_domuuid_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_domain_id] [int] NULL,
[source_unit_id] [int] NULL,
[domuuid] [uniqueidentifier] NULL,
[hwuuid] [uniqueidentifier] NULL,
[hwprocmfgr] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwprocmodel] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwproctype] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwprocspeed] [int] NULL,
[hwprocid] [int] NULL
) ON [PRIMARY]

GO