SQL Server Management Studio (SSMS) provides a unified management environment for any SQL system. All components of SQL Server, Azure SQL Database, and Azure Synapse Analytics may be accessed, configured, managed, administered, and developed using SSMS. SSMS is a single, comprehensive application that combines a wide range of graphical tools with a variety of rich script editors to provide you access to SQL Server.
Mainly there are 5 Components in SQL Server Management Studio
> Object Explorer
Object Explorer allows you to see and manage all of the objects in one or more SQL Server instances.
> Template Explorer
How to utilize Template Explorer to create and maintain boilerplate text that you may use to speed up query and script development.
> Solution Explorer
How to create projects using the deprecated Solution Explorer to manage administration elements like scripts and queries.
> Visual Database Tools
How to make use of Management Studio's visual design capabilities.
> Query and Text Editors
How to use the Management Studio language editors to interactively build and debug queries and scripts.
Hello, myself Gregory. Love to share new technology news and its application.
No comments:
Post a Comment