Cross-Database Queries in Azure SQL Database (Vertical Partitioning) - Error when creating EXTERNAL TABLE from EXTERNAL DATA SOURCE

Question

_{Thursday, May 12, 2016 10:46 AM}

I followed the examples detailed here :

https://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-query-getting-started-vertical/

However, when I attempt to create the external table, I get the following error :

Msg 46518, Level 16, State 7, Line 18

The option 'IDENTITY' is not supported with external tables for sharded data.

All replies (2)

_{Thursday, May 12, 2016 5:26 PM ✅Answered}

Try creating the column without the IDENTITY constraint. IDENTITY can only be enforced at the local table level, i.e., the remote table in the remote database you are pointing to. The global view that you establish using the external table does not enforce identity.

Thanks,

Torsten

This posting is provided "AS IS" with no warranties, and confers no rights.

_{Friday, May 13, 2016 7:08 AM}

That worked. Thank you !