Linked Servers Syntax - "drop if exists" and "select * into from"

• Solitary Reaper

  Right there with Babe

  Points: 718

  More actions

  January 23, 2013 at 11:25 pm

  #287941

  Hi,

  Can anyone let me know the syntax for "drop if exists" and "select * into from" using Linked Server tables.

• tony28

  SSCertifiable

  Points: 7112

  More actions

  January 23, 2013 at 11:48 pm

  #1580364

  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 🙂