EnterpriseDW
 FK_dbo_FactHoursReportedByDay_DateReportedSK
  Properties
Property Value
Name FK_dbo_FactHoursReportedByDay_DateReportedSK
Columns DateReportedSK
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].[FactHoursReportedByDay]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactHoursReportedByDay_DateReportedSK] FOREIGN KEY([DateReportedSK])
REFERENCES [DimDate] ([DateSK])
ALTER TABLE [dbo].[FactHoursReportedByDay] CHECK CONSTRAINT [FK_dbo_FactHoursReportedByDay_DateReportedSK]
Powered by BI Documenter