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

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

Comments

  • 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.