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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Linked Servers Syntax - "drop if exists" and...

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

Rate Topic

Display Mode

Topic Options

Author

Message

Solitary Reaper

Posted Wednesday, January 23, 2013 11:25 PM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 3:20 AM
Points: 38, Visits: 244

Hi,

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

Post #1410909

tony28

Posted Wednesday, January 23, 2013 11:48 PM

Valued Member

Group: General Forum Members
Last Login: Today @ 1:26 AM
Points: 65, Visits: 199

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 :)

Post #1410916

« Prev Topic | Next Topic »

Permissions