Expand table → → right-click → New Index → choose columns.

When you open SSMS, you see the dialog:

SSMS is a free software application developed by Microsoft that allows users to manage SQL Server databases. It is the successor to the old Enterprise Manager and Query Analyzer tools. SSMS provides a unified interface for database administrators, developers, and data architects to perform various tasks, such as:

SSMS + Azure Data Studio together is a powerful combo: SSMS for admin, ADS for development.

SQL Server Management Studio (SSMS) is a powerful tool for managing SQL Server databases. Its comprehensive set of features, benefits, and best practices make it an essential tool for database administrators and developers. By following the steps outlined in this article, you can get started with SSMS and start managing your SQL Server databases more efficiently. Whether you are a beginner or an experienced DBA, SSMS provides the tools and features you need to design, implement, and manage complex databases.

SQL Server Management Studio (SSMS) is the integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. It provides a single comprehensive utility that combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server for developers and database administrators of all skill levels. Core Functionalities