[aiowner].[ai_hwdef_mac_kpi

[aiowner].[ai_hwdef_mac_kpi_p]

(local) > mdb > Tables > aiowner.ai_hwdef_mac_kpi_p

Properties
Columns
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	248
Created	9:12:21 AM Thursday, November 06, 2008
Last Modified	9:12:21 AM Thursday, November 06, 2008

Columns

Name	Data Type	Max Length (Bytes)	Allow Nulls	Default
hwuuid	uniqueidentifier	16		(newid())
hwmac	nvarchar(16)	32		('')

SQL Script

CREATE TABLE [aiowner].[ai_hwdef_mac_kpi_p]
(
[hwuuid] [uniqueidentifier] NOT NULL CONSTRAINT [DF__ai_hwdef___hwuui__00266220] DEFAULT (newid()),
[hwmac] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__ai_hwdef___hwmac__011A8659] DEFAULT ('')
) ON [PRIMARY]
GO

Uses

aiowner