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