Relationship:
FK_CurrencyRate_Currency_FromCurrencyCode
on
CurrencyRate
Relationship properties
| Name | Value |
| Not For Replication |
FK columns
| CurrencyRate column | Currency column | Type |
| FromCurrencyCode | CurrencyCode | nchar |
Extended properties
| Name | Value |
| MS_Description | Foreign key constraint referencing Currency.FromCurrencyCode. |
SQL
ALTER TABLE [Sales].[CurrencyRate] WITH CHECK ADD CONSTRAINT [FK_CurrencyRate_Currency_FromCurrencyCode] FOREIGN KEY ([FromCurrencyCode]) REFERENCES [Sales].[Currency] ([CurrencyCode]) ALTER TABLE [Sales].[CurrencyRate] CHECK CONSTRAINT [FK_CurrencyRate_Currency_FromCurrencyCode] GO EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing Currency.FromCurrencyCode.', 'SCHEMA', N'Sales', 'TABLE', N'CurrencyRate', 'CONSTRAINT', N'FK_CurrencyRate_Currency_FromCurrencyCode' GO |
See also