Table - dbo.ST_COURSE_A_ADLT_ED

Properties

Property	Value
Name	ST_COURSE_A_ADLT_ED_SUBJ
Schema	dbo
Row Count	8
Data Size	8 KB
Index Size	24 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
ADLT_ED_SUBJ	varchar(2)	True	False	False
ADLT_ED_SUBJ_COUNT	smallint(5, 0)	False	False	False
cnxarraycolumn	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
U3NH9KTJFRFVSH	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_ADLT_ED_SUBJ depends on)

Name

Type

Child Dependencies (objects that depend on dbo.ST_COURSE_A_ADLT_ED_SUBJ)

Name

Type

Extended Properties

Object

Property

Value

Annotations

Object

Property

Value

DDL

/****** Object: Table [dbo].[ST_COURSE_A_ADLT_ED_SUBJ] Script Date: 03/09/2017 16:46:01 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_COURSE_A_ADLT_ED_SUBJ](
    [ISN_ST_COURSE_A] [int] NOT NULL,
    [ADLT_ED_SUBJ_COUNT] [smallint] NOT NULL,
    [ADLT_ED_SUBJ] [varchar](2) 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

ADLT_ED_SUBJ	ADLT_ED_SUBJ_COUNT	cnxarraycolumn	ISN_ST_COURSE_A	RowUpdatedOn
LA	1	0	30754	2017-02-06T11:10:55.309-05:00
MA	1	0	30748	2017-02-06T11:10:55.309-05:00
RE	1	0	30745	2017-02-06T11:10:55.309-05:00
EN	1	0	30752	2017-02-06T11:10:55.309-05:00
MA	1	0	30753	2017-02-06T11:10:55.309-05:00
RE	1	0	30747	2017-02-06T11:10:55.309-05:00
RE	1	0	30746	2017-02-06T11:10:55.309-05:00
MA	1	0	30744	2017-02-06T11:10:55.309-05:00