CREATE TABLE with inline INDEX statement should allow INCLUDE columns - by Scott Brickey

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 3103792 Comments
Status Resolved Workarounds
Type Suggestion Repros 0
Opened 9/20/2016 1:16:04 PM
Access Restriction Public


When creating a table, an INDEX can be defined "inline", but the inline index declaration does not support the option to INCLUDE additional columns in the index.

I wish for INCLUDE columns to be supported.
Sign in to post a comment.
Posted by Microsoft on 3/6/2017 at 10:58 AM
Hi Scott,

Thanks for bringing this to our attention. We have a work item tracking this work and it will be addressed in a future release of SQL Server.