CREATE INDEX statement INCLUDE clause offers no suggestions

kyle.neier

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

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.