EnterpriseDW
 FK_FactPriorEnrollmentSnapshot_DimDate
  Properties
Property Value
Name FK_FactPriorEnrollmentSnapshot_DimDate
Columns DateSK
Referenced Table dbo.DimDate
Referenced Columns DateSK
Referenced Key PK_Dim_Date
Is Checked True
Description
  Extended Properties
Object Property Value
  DDL
ALTER TABLE [dbo].[FactPriorEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactPriorEnrollmentSnapshot_DimDate] FOREIGN KEY([DateSK])
REFERENCES [DimDate] ([DateSK])
ALTER TABLE [dbo].[FactPriorEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactPriorEnrollmentSnapshot_DimDate]
Powered by BI Documenter