Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The ASC clause
Message
 
 
To
09/01/2010 19:39:10
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01442956
Message ID:
01442960
Views:
32
This message has been marked as a message which has helped to the initial question of the thread.
Yes. It's all documented in BOL. The defaults are underlined.

>If I have a create index syntax starting like this:
>
>
>   CREATE Clustered INDEX [Combo1] ON [Dispatch] ([NoEntity])
>
>
>We can see that the list of fields do not have the ASC clause. The next one has:
>
>
>   CREATE Clustered INDEX [Combo1] ON [Dispatch] ([NoEntity] ASC)
>
>
>When the ASC clause is not there, does this mean the default is ASC?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform