DWStaging
 dbo.ST_COURSE_A_CRS_DESC (Table)
  Properties
Property Value
Name ST_COURSE_A_CRS_DESC
Schema dbo
Row Count 106457
Data Size 6464 KB
Index Size 1832 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
cnxarraycolumn
smallint(5, 0)
False
False
False
 
CRS_DESC
varchar(50)
True
False
False
 
CRS_DESC_COUNT
smallint(5, 0)
False
False
False
 
ISN_ST_COURSE_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_COURSE_A, cnxarraycolumn
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_COURSE_A_CRS_DESC depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_COURSE_A_CRS_DESC)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_COURSE_A_CRS_DESC] Script Date: 03/09/2017 16:46:01 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_COURSE_A_CRS_DESC](
    [ISN_ST_COURSE_A] [int] NOT NULL,
    [CRS_DESC_COUNT] [smallint] NOT NULL,
    [CRS_DESC] [varchar](50) 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
cnxarraycolumn CRS_DESC CRS_DESC_COUNT ISN_ST_COURSE_A RowUpdatedOn
0 AP ORGAN SEC F 1 2917 2017-02-06T11:10:22.518-05:00
0 STRUCTNG BEHVIOR 1 9155 2017-02-06T11:10:22.939-05:00
3 introduces the students to bricklaying on 9 25145 2017-02-06T11:10:25.014-05:00
4 learn how to use observations of teacher 9 29115 2017-02-06T11:10:26.324-05:00
0 VISION 2000 1 7119 2017-02-06T11:10:22.814-05:00
2 HR Certification: SHRM Certified Professional 8 30384 2017-02-06T11:10:26.839-05:00
3 sound. Special emphasis is placed on working as 6 23095 2017-02-06T11:10:24.437-05:00
0 WATER EXERC 1 11520 2017-02-06T11:10:23.173-05:00
1 higher), VPI0100, VPI0200, VPI0300 ~ 9 29416 2017-02-06T11:10:26.434-05:00
2 1 lecture and DEA0801 Clinical Practice 2 lecture. 8 29696 2017-02-06T11:10:26.543-05:00
Powered by BI Documenter