What are the challenges you face when working across database platforms? Take the survey

CREATE INDEX statement INCLUDE clause offers no suggestions

kyle.neierkyle.neier Posts: 4
edited September 3, 2009 8:05AM in SQL Prompt Previous Versions
SQL 2008 Management Studio 10.0.1600.22
SQL 2005 x86 9.00.4035
SQL Prompt

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
CREATE TABLE TestInclude (id INT IDENTITY(1,1) NOT NULL, Value1 CHAR(2), Value2 VARCHAR(2))
--refresh SQL Prompt to see new table before typing
CREATE NONCLUSTERED INDEX IX_TestInclude_1 ON TestInclude (Value1) INCLUDE (Value2)
DROP TABLE TestInclude

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




  • Options
    Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.