Skip to main content
added 303 characters in body
Source Link
Aaron Bertrand
  • 181.5k
  • 28
  • 402
  • 619

The syntax for inline index declaration was added in SQL Server 2014, though that isis was absolutely unclear in the official CREATE TABLE documentation. After speaking to the documentation owners, that topic now accurately reflects that inline index syntax is only valid starting with SQL Server 2014 (and some variations in 2016):

enter image description here

The other serversinstances, where this syntax is working for you, must be >=on SQL Server 2014 (any compatibility level)or newer.

On 2012, regardless of compatibility level, you'll need to create the index separately.

The syntax for inline index declaration was added in SQL Server 2014, though that is absolutely unclear in the official CREATE TABLE documentation. The other servers where this is working must be >= 2014 (any compatibility level).

On 2012, regardless of compatibility level, you'll need to create the index separately.

The syntax for inline index declaration was added in SQL Server 2014, though that is was absolutely unclear in the official CREATE TABLE documentation. After speaking to the documentation owners, that topic now accurately reflects that inline index syntax is only valid starting with SQL Server 2014 (and some variations in 2016):

enter image description here

The other instances, where this syntax is working for you, must be on SQL Server 2014 or newer.

On 2012, regardless of compatibility level, you'll need to create the index separately.

Source Link
Aaron Bertrand
  • 181.5k
  • 28
  • 402
  • 619

The syntax for inline index declaration was added in SQL Server 2014, though that is absolutely unclear in the official CREATE TABLE documentation. The other servers where this is working must be >= 2014 (any compatibility level).

On 2012, regardless of compatibility level, you'll need to create the index separately.