SQL Server Management – Index propertiers keyboard shortcut?

While doing development in SQL Server Management Studio (SSMS), I frequently want to check the properties of a number of index on a specific table from within the Object Explorer:

Screenshot from SSMS

  • Can't see created tables in Object Explorer - Microsoft SQL Management Studio
  • With EF6 do I need to use COMMIT and ROLLBACK inside a Stored Procedure?
  • Update table inner join with 3rd table
  • Impersonate remote user in vb.net to access MS SQL Server
  • Grant Select on a view not base table when base table is in a different database
  • Add new column and assign values from existing table
  • Pulling up the index properties to see the columns included in the index, one can double-click the index name in Object Explorer, or alternatively use the Menu Key and then using Up to select Properties, and then hitting Enter.

    I checked the SQL Server Management Studio Keyboard Shortcuts list, but did not manage to find the answer to my question.

    Is there a one-key shortcut that could be used to pull up the index properties instead?

    2 Solutions collect form web for “SQL Server Management – Index propertiers keyboard shortcut?”

    I have just tried to find any context menus registered in SSMS concerning Index in Object explorer, but unfortunately it looks like that it is 100% built dynamically. So it is impossible to assign a shortcut. Generally, you can assign shortcut on any command, that is registered as menu command in SSMS. But no luck here.

    No, I don’t believe so. Usually if someone wants that level of speed in accessing information about indexes, they’ll just issue an sp_helpindex command in T-SQL or query sys.indexes for the information they want.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.