DWStaging
 dbo.ST_STDNT_OBJ_AWD_A_TRNSCRPT_MSG_CD (Table)
  Properties
Property Value
Name ST_STDNT_OBJ_AWD_A_TRNSCRPT_MSG_CD
Schema dbo
Row Count 0
Data Size 0 KB
Index Size 0 KB
Create Date 2/26/2016 9:04 AM
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_ST_STDNT_OBJ_AWD_A
int(10, 0)
False
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
TRNSCRPT_MSG_CD
varchar(2)
True
False
False
 
TRNSCRPT_MSG_CD_COUNT
smallint(5, 0)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_STDNT_OBJ_AWD_A, cnxarraycolumn
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_STDNT_OBJ_AWD_A_TRNSCRPT_MSG_CD depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_STDNT_OBJ_AWD_A_TRNSCRPT_MSG_CD)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_STDNT_OBJ_AWD_A_TRNSCRPT_MSG_CD] Script Date: 03/09/2017 16:46:28 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_STDNT_OBJ_AWD_A_TRNSCRPT_MSG_CD](
    [ISN_ST_STDNT_OBJ_AWD_A] [int] NOT NULL,
    [TRNSCRPT_MSG_CD_COUNT] [smallint] NOT NULL,
    [TRNSCRPT_MSG_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [cnxarraycolumn] [smallint] NOT NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
Powered by BI Documenter