SQL Server 2017

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

CREATE TABLE t1(i INT PRIMARY KEY);
CREATE TABLE t2(i INT PRIMARY KEY);
CREATE TABLE t3(i INT PRIMARY KEY, t2_id INT REFERENCES t2(i));
DROP TABLE IF EXISTS t1,t2,t3;
Msg 3726 Level 16 State 1 Line 1
Could not drop object 't2' because it is referenced by a FOREIGN KEY constraint.

SELECT * FROM t1;
Msg 208 Level 16 State 1 Line 1
Invalid object name 't1'.

SELECT * FROM t2;


i


SELECT * FROM t3;
Msg 208 Level 16 State 1 Line 1
Invalid object name 't3'.