Hello I have

on the server 1.1.1.2

i think

SELECT * FROM [1.1.1.1].DATABASE.dbo.TABLE

and try

DROP TABLE table_name [1.1.1.1].DATABASE.dbo.TABLE;

IF EXISTS (SELECT COUNT(*) FROM sys.object WHERE OBJECT_ID = OBJECT_ID(N'TABLE'))

DROP TABLE IF EXISTS table_name [1.1.1.1].DATABASE.dbo.TABLE;

but the second query i didnt use before 🙂