Home > SQL Server 2016 > What is external tables for in SQL Server 2016 ? – MSDN TSQL forum

What is external tables for in SQL Server 2016 ? – MSDN TSQL forum

–> Question:

Running 2016 CTP3.

I would appreciate your personal comments/experience more than links.

–> Answer:

External Tables in SQL Server 2016 are to setup the new Polybase feature with SQL Server.

With this new feature (Polybase) you can connect to Azure blog storage or Hadoop to query non-relational data from SSMS and integrate with SQL Server relational tables.

You can check some details here, where I’ve : https://sqlwithmanoj.com/2015/05/29/installing-sql-server-2016-ctp2-and-new-features-in-ssms/

Check here how to setup Polybase: https://msdn.microsoft.com/en-IN/library/mt163689.aspx


Ref link.

  1. joymon
    August 14, 2017 at 1:28 am

    Does this external tables support primary key foreign key relations? Hope it cant as its not relation data. Any official documentation on what are the limits or differences with normal tables.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: