sektor81 (8/11/2014)
I wonder whether there's documentation about inline syntax for indexes for SQL Server 2014? I couldn't find it here.
CREATE TABLE Consumer
(
Account nvarchar(20) null,
Consumption float null,
INDEX IX_Consumer_Account NONCLISTURED (Account)
);
The only indexes that can be created during table creation are those that will be created by unique constraints. For example, PK's.
--Jeff Moden
Change is inevitable... Change for the better is not.