I suggest you ...

SQL index during table creation

BUG!

The following is valid SQL:

CREATE TABLE [x] ( [id] , INDEX [x_index_id] CLUSTERED ( [id] ) )

works fine (SQL2012, probably earlier).. but VS (2013) flags the INDEX keyword, as well as the column being indexed.

similar examples on MSDN: https://msdn.microsoft.com/en-us/library/ms174979.aspx

0 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Scott Brickey shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base