Tables [aiowner].[ai_undef_prop_s]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count157
Created9:12:28 AM Thursday, November 06, 2008
Last Modified7:38:34 PM Friday, March 19, 2010
Columns
NameData TypeMax Length (Bytes)Allow Nulls
source_domuuid_charvarchar(36)36
Yes
source_hwuuid_charvarchar(36)36
Yes
Indexes ai_undef_prop_s_ak2: source_domain_idsource_domain_idint4
Yes
Indexes ai_undef_prop_s_ak3: source_unit_idsource_unit_idint4
Yes
domuuiduniqueidentifier16
Yes
Indexes ai_undef_prop_s_ak1: hwuuidhwuuiduniqueidentifier16
Yes
source_host_namenvarchar(255)510
Yes
lscandateint4
Yes
Indexes Indexes
NameColumns
ai_undef_prop_s_ak1hwuuid
ai_undef_prop_s_ak2source_domain_id
ai_undef_prop_s_ak3source_unit_id
SQL Script
CREATE TABLE [aiowner].[ai_undef_prop_s]
(
[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,
[source_host_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[lscandate] [int] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_undef_prop_s_ak1] ON [aiowner].[ai_undef_prop_s] ([hwuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_undef_prop_s_ak2] ON [aiowner].[ai_undef_prop_s] ([source_domain_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_undef_prop_s_ak3] ON [aiowner].[ai_undef_prop_s] ([source_unit_id]) ON [PRIMARY]
GO
Uses