CODEWITHSUNDEEP
azuresql-server-2005
Anil Patel
Anil Patel

Reputation: 81

Unable to create EXTERNAL TABLE at Azure SQL SERVER

CREATE EXTERNAL DATA SOURCE EX_SOURCE 
WITH ( 
TYPE = RDBMS,
LOCATION = 'SERVER.database.windows.net',
DATABASE_NAME = 'DB_NAME',
CREDENTIAL = "CREDENTIAL"
);

Getting error, Incorrect syntax near EXTERNAL.

Does anyone know the solution?

Upvotes: 0

Views: 549

Answers (1)

Martyn C
Martyn C

Reputation: 1139

You can only run CREATE EXTERNAL DATA SOURCE as an elastic database query which has to be on a V12 database.

You can find more information on running this query on the documentation: https://msdn.microsoft.com/en-GB/library/dn935022.aspx

Upvotes: 1

Related Questions