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.


3
1
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

Description

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.

Devin