SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE dbo.Customer_Branch(ID INT PRIMARY KEY);
INSERT INTO Customer_Branch
VALUES (1);
1 rows affected

CREATE SCHEMA Spectrum;
CREATE TABLE [Spectrum].[PO_PURCHASE_ORDER_HEADER_MC](Customer_Branch_ID INT);
INSERT INTO [Spectrum].[PO_PURCHASE_ORDER_HEADER_MC](Customer_Branch_ID)
VALUES (1);
1 rows affected

ALTER TABLE [Spectrum].[PO_PURCHASE_ORDER_HEADER_MC]
WITH CHECK
ADD CONSTRAINT [[Customer_Branch_Spectrum.PO_PURCHASE_ORDER_HEADER_MC_FK]]]
FOREIGN KEY([Customer_Branch_ID])
REFERENCES [dbo].[Customer_Branch] ([ID]);
SELECT *
FROM [Spectrum].[PO_PURCHASE_ORDER_HEADER_MC];


Customer_Branch_ID


1


SELECT OBJECT_NAME(constraint_object_id)
FROM sys.foreign_key_columns;


(No column name)


[Customer_Branch_Spectrum.PO_PURCHASE_ORDER_HEADER_MC_FK]