Tables [aiowner].[ai_ipdef_prop_p]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count318
Created11:24:55 PM Monday, January 10, 2011
Last Modified11:24:55 PM Monday, January 10, 2011
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
hwuuiduniqueidentifier16
No
(newid())
ipaddrvarchar(32)32
No
ipmaskvarchar(32)32
Yes
ipnwaddrvarchar(32)32
Yes
SQL Script
CREATE TABLE [aiowner].[ai_ipdef_prop_p]
(
[hwuuid] [uniqueidentifier] NOT NULL CONSTRAINT [DF__ai_ipdef___hwuui__1FE166A0] DEFAULT (newid()),
[ipaddr] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ipmask] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ipnwaddr] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
Uses