DWOperations
 dbo.Staged_dbo_DimCheckType__Type1Update (Table)
  Properties
Property Value
Name Staged_dbo_DimCheckType__Type1Update
Schema dbo
Row Count 0
Data Size 0 KB
Index Size 0 KB
Create Date 3/9/2017 10:45 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
CheckType
varchar(30)
False
False
False
 
CheckTypeCode
varchar(3)
False
False
False
 
CheckTypeCodeAK
varchar(3)
False
False
False
 
CheckTypeSK
int(10, 0)
False
False
False
(1 / 1)
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.Staged_dbo_DimCheckType__Type1Update depends on)
Name Type
  Child Dependencies (objects that depend on dbo.Staged_dbo_DimCheckType__Type1Update)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[Staged_dbo_DimCheckType__Type1Update] Script Date: 03/09/2017 17:21:38 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Staged_dbo_DimCheckType__Type1Update](
    [CheckTypeSK] [int] IDENTITY(1,1) NOT NULL,
    [CheckTypeCodeAK] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CheckTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CheckType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
Powered by BI Documenter