DWStaging
 dbo.IA_SECURITY_LOG_A_LAST_PASSWORDS (Table)
  Properties
Property Value
Name IA_SECURITY_LOG_A_LAST_PASSWORDS
Schema dbo
Row Count 4288
Data Size 112 KB
Index Size 128 KB
Create Date 11/7/2012 2:39 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
cnxarraycolumn
smallint(5, 0)
False
False
False
 
ISN_IA_SECURITY_LOG_A
int(10, 0)
False
False
False
 
LAST_PASSWORDS
varchar(16)
True
False
False
 
LAST_PASSWORDS_COUNT
smallint(5, 0)
False
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_IA_SECURITY_LOG_A, cnxarraycolumn
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.IA_SECURITY_LOG_A_LAST_PASSWORDS depends on)
Name Type
  Child Dependencies (objects that depend on dbo.IA_SECURITY_LOG_A_LAST_PASSWORDS)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[IA_SECURITY_LOG_A_LAST_PASSWORDS] Script Date: 03/09/2017 16:45:38 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[IA_SECURITY_LOG_A_LAST_PASSWORDS](
    [ISN_IA_SECURITY_LOG_A] [int] NOT NULL,
    [LAST_PASSWORDS_COUNT] [smallint] NOT NULL,
    [LAST_PASSWORDS] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [cnxarraycolumn] [smallint] NOT NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
cnxarraycolumn ISN_IA_SECURITY_LOG_A LAST_PASSWORDS LAST_PASSWORDS_COUNT RowUpdatedOn
0 3818 HqHlwu 1 2017-02-06T11:18:27.946-05:00
0 10491 HqHlwu 1 2017-02-06T11:18:28.445-05:00
0 2984 HqHlwu 1 2017-02-06T11:18:27.915-05:00
0 310 HqHlwu 1 2017-02-06T11:18:27.915-05:00
0 5297 HqHlwu 1 2017-02-06T11:18:28.055-05:00
0 6075 HqHlwu 2 2017-02-06T11:18:28.414-05:00
0 5661 HqHlwu 1 2017-02-06T11:18:28.071-05:00
0 3787 HqHlwu 1 2017-02-06T11:18:27.946-05:00
0 5628 HqHlwu 1 2017-02-06T11:18:28.071-05:00
0 6321 NpJqwu 1 2017-02-06T11:18:28.414-05:00
Powered by BI Documenter