MS SQL Server – Getting Object information quickly in MS SQL Management Studio Highlight an object in a query statement and then press Alt + F1 This will display column, identity, and index information for tables. Source