Table - dbo.Staged_dbo_DimStudent_

Properties

Property	Value
Name	Staged_dbo_DimStudent__Type2Expired
Schema	dbo
Row Count	0
Data Size	0 KB
Index Size	0 KB
Create Date	8/22/2012 3:49 PM
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
StudentSK	int(10, 0)	False	False	False	(1 / 1)

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

Name

Type

Child Dependencies (objects that depend on dbo.Staged_dbo_DimStudent__Type2Expired)

Name

Type

Extended Properties

Object

Property

Value

Annotations

Object

Property

Value

DDL

/****** Object: Table [dbo].[Staged_dbo_DimStudent__Type2Expired] Script Date: 03/09/2017 17:21:43 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Staged_dbo_DimStudent__Type2Expired](
    [StudentSK] [int] IDENTITY(1,1) 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]