>>No, default is NONCLUSTERED
>
>So, for the purpose of a better syntax, it is a good practice to include nonclustered in the command, even if that is the default. Which would then mean that when I would want to create a clustered index, I would then be forced to include clustered in the command line.
Yes, I would do that. After a while it's easy to forget what default is.
--sb--