EnterpriseDW
 FK_dbo_FactProgramRetentionSnapshot_ProgramRetentionCohortTermSK
  Properties
Property Value
Name FK_dbo_FactProgramRetentionSnapshot_ProgramRetentionCohortTermSK
Columns ProgramRetentionCohortTermSK
Referenced Table dbo.DimTerm
Referenced Columns TermSK
Referenced Key PK_dbo_DimTerm
Is Checked True
Description
  Extended Properties
Object Property Value
  DDL
ALTER TABLE [dbo].[FactProgramRetentionSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactProgramRetentionSnapshot_ProgramRetentionCohortTermSK] FOREIGN KEY([ProgramRetentionCohortTermSK])
REFERENCES [DimTerm] ([TermSK])
ALTER TABLE [dbo].[FactProgramRetentionSnapshot] CHECK CONSTRAINT [FK_dbo_FactProgramRetentionSnapshot_ProgramRetentionCohortTermSK]
Powered by BI Documenter