How to create nonclustered index in Create Table.
Posted
by isthatacode
on Stack Overflow
See other posts from Stack Overflow
or by isthatacode
Published on 2010-04-22T10:20:01Z
Indexed on
2010/04/22
10:23 UTC
Read the original article
Hit count: 381
Create table FavoriteDish
(
FavID int identity (1,1) primary key not null,
DishID int references Dishes(DishID) not null ,
CelebrityName nvarchar(100) nonclustered not null
)
This results in - Incorrect syntax near the keyword 'nonclustered'. I referred the MSDN help for create table syntax. I am not sure whats wrong here?
Thanks for reading.
© Stack Overflow or respective owner
