Shows the current hash indexes and the hash index properties. Hash indexes are supported only on In-Memory OLTP (In-Memory Optimization).
The sys.hash_indexes view contains the same columns as the sys.indexes view and an additional column named bucket_count. For more information about the other columns in the sys.hash_indexes view, see sys.indexes (Transact-SQL).
Applies to: SQL Server (SQL Server 2014 through current version).
The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission.. For more information, see Metadata Visibility Configuration.