[aiowner].[ai_hwdef_login_lscandate_rel

[aiowner].[ai_hwdef_login_lscandate_rel_p]

(local) > mdb > Tables > aiowner.ai_hwdef_login_lscandate_rel_p

Properties
Columns
SQL Script
Uses

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

Columns

Name	Data Type	Max Length (Bytes)	Default
hwuuid	uniqueidentifier	16	(newid())
loginid	nvarchar(128)	256
logindomain	nvarchar(128)	256
logindate	datetime	8	(getdate())

SQL Script

CREATE TABLE [aiowner].[ai_hwdef_login_lscandate_rel_p]
(
[hwuuid] [uniqueidentifier] NOT NULL CONSTRAINT [DF__ai_hwdef___hwuui__259A3FF6] DEFAULT (newid()),
[loginid] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[logindomain] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[logindate] [datetime] NULL CONSTRAINT [DF__ai_hwdef___login__268E642F] DEFAULT (getdate())
) ON [PRIMARY]

GO

Uses

aiowner