How can we help you today? How can we help you today?

CREATE INDEX statement INCLUDE clause offers no suggestions

SQL 2008 Management Studio 10.0.1600.22
SQL 2005 x86 9.00.4035
SQL Prompt 4.0.2.53

When typing the "create nonclustered index" statement, the suggestions list is populated for the key columns, but after the include is typed, only the canned suggestions appear. The following code can be used to show the behavior:
USE tempdb
go
CREATE TABLE TestInclude (id INT IDENTITY(1,1) NOT NULL, Value1 CHAR(2), Value2 VARCHAR(2))
go
--refresh SQL Prompt to see new table before typing
CREATE NONCLUSTERED INDEX IX_TestInclude_1 ON TestInclude (Value1) INCLUDE (Value2)
go
DROP TABLE TestInclude


Is this an option that needs to be changed or something that needs added to the product?

Thanks!

Kyle
kyle.neier
0

Comments

1 comment

Sort by
  • Anu D
    Thanks for your post Kyle and apologies for the inconvenience caused by this issue.

    I was able to replicate the issue and have raised this as a bug (SP-2797) so that our developers will look into this and fix it in our future release.

    Thanks for your patience with this issue.
    Anu D
    0

Add comment

Please sign in to leave a comment.