SQL Server 2017

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

CREATE TABLE dbo.TestTable1 (ID int PRIMARY KEY CLUSTERED);
CREATE TABLE dbo.TestTable2 (ID int PRIMARY KEY CLUSTERED);

CREATE TABLE dbo.StagingTable (fID1 int FOREIGN KEY REFERENCES dbo.TestTable1(ID),
                               fID2 int FOREIGN KEY REFERENCES dbo.TestTable2(ID));
INSERT INTO dbo.TestTable1 (ID)
VALUES(1),(2);
INSERT INTO dbo.TestTable2 (ID)
VALUES(4),(5);
INSERT INTO dbo.StagingTable (fID1,
                              fID2)
VALUES(1,4),
      (1,5),
      (2,4);
7 rows affected

TRUNCATE TABLE dbo.StagingTable;
--This, however, will fail
TRUNCATE TABLE dbo.TestTable1;
Msg 4712 Level 16 State 1 Line 2
Cannot truncate table 'dbo.TestTable1' because it is being referenced by a FOREIGN KEY constraint.