Does SQL Server support hash indexes?

Question

Are all the indexes in SQL Server B Tree?
Surely primary keys and foreign should be hash based indexes?

Answer 1

Not all indexes in SQL Server are B-tree indexes (SQL Server 2012 added columnstore indexes which are a bit different), but there is no such thing as a hash-based index there (yet).

Answer 2

Here's a pretty straight forward article explaining that all indices are b tree indices in SQL Server:

http://msdn.microsoft.com/en-us/library/ms177443(v=sql.105).aspx

I think if you want to get more into the nitty gritty of specific RDBMS' implementations, you could try posting to http://dba.stackexchange.com