Table - dbo.Staged_dbo_DimStudentObjective_

Properties

Property	Value
Name	Staged_dbo_DimStudentObjective__Type2Expired
Schema	dbo
Row Count	0
Data Size	0 KB
Index Size	0 KB
Create Date	8/28/2013 9:56 AM
Description

Columns

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
RowChangeReason	varchar(200)	False	False	False
RowEndDate	datetime(23, 3)	False	False	False
RowIsCurrent	char(1)	False	False	False
StudentObjectiveSK	int(10, 0)	False	False	False

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_DimStudentObjective__Type2Expired depends on)

Name

Type

Child Dependencies (objects that depend on dbo.Staged_dbo_DimStudentObjective__Type2Expired)

Name

Type

Extended Properties

Object

Property

Value

Annotations

Object

Property

Value

DDL

/****** Object: Table [dbo].[Staged_dbo_DimStudentObjective__Type2Expired] Script Date: 03/09/2017 17:21:43 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Staged_dbo_DimStudentObjective__Type2Expired](
    [StudentObjectiveSK] [int] NOT NULL,
    [RowIsCurrent] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowEndDate] [datetime] NOT NULL,
    [RowChangeReason] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]