DWStaging
 dbo.ST_CLASS_SCHD_A_CLS_SCHD_DAY (Table)
  Properties
Property Value
Name ST_CLASS_SCHD_A_CLS_SCHD_DAY
Schema dbo
Row Count 563352
Data Size 11400 KB
Index Size 9544 KB
Create Date 8/15/2012 12:45 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
CLS_SCHD_DAY
varchar(1)
True
False
False
 
CLS_SCHD_DAY_COUNT
smallint(5, 0)
False
False
False
 
cnxarraycolumn
smallint(5, 0)
False
False
False
 
ISN_ST_CLASS_SCHD_A
int(10, 0)
False
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_CLASS_SCHD_A, cnxarraycolumn
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_CLASS_SCHD_A_CLS_SCHD_DAY depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_CLASS_SCHD_A_CLS_SCHD_DAY)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_CLASS_SCHD_A_CLS_SCHD_DAY] Script Date: 03/09/2017 16:46:00 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_CLASS_SCHD_A_CLS_SCHD_DAY](
    [ISN_ST_CLASS_SCHD_A] [int] NOT NULL,
    [CLS_SCHD_DAY_COUNT] [smallint] NOT NULL,
    [CLS_SCHD_DAY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [cnxarraycolumn] [smallint] NOT NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
CLS_SCHD_DAY CLS_SCHD_DAY_COUNT cnxarraycolumn ISN_ST_CLASS_SCHD_A RowUpdatedOn
T 3 0 129892 2017-02-06T10:38:13.784-05:00
T 1 0 33538 2017-02-06T10:38:06.202-05:00
T 2 0 193516 2017-02-06T10:38:18.979-05:00
R 2 1 208345 2017-02-06T10:38:20.242-05:00
N 6 1 193055 2017-02-06T10:38:18.932-05:00
M 2 0 37140 2017-02-06T10:38:06.561-05:00
T 2 0 77381 2017-02-06T10:38:09.697-05:00
R 1 0 251566 2017-02-06T10:38:24.002-05:00
R 4 3 61505 2017-02-06T10:38:08.464-05:00
W 4 2 256021 2017-02-06T10:38:24.423-05:00
Powered by BI Documenter