The problem of creating an index with columns enabled (SQL Server Express)

Question

I am using Visual C # 2008 Express Edition Explorer / Database Explorer with SQL Server Express 2008.

I created a table and want to add an index. But the index will exceed 900 bytes. One way is to use included columns in the index. Unfortunately, the Enabled Columns property is disabled in the index designer, and I have not found a way to enable it.

Can someone tell me how to enable a property? Is there any other way to add included columns to the index using the constructor? Is this feature generally supported by SQL Server Express?

Answer 1

, , "" " ...". , , .

Answer 2

, , . , . CREATE INDEX MSDN, .

, , Express Express :

create table T1 (
    ID int not null,
    Val1 varchar(10) not null
)
go
create unique nonclustered index IX_T1 on T1 (ID) INCLUDE (Val1)
go

, , . , (, , GUI), , INCLUDE . , , , .