I am curious about why the clustering should be obvious from the name of the index?

Clustered Index - IDX

Nonclustered Index - NDX

Isnt it a bit awkward to have to change the name of the index when you change a clustered index to a nonclustered?

The different standards I have used denotes if the index is on a foreign key or not. If not it is just numbered.