Icons in SQL management studio

Jonathan Brotto 420

Like to know what the icons mean SQL management studio. Some are the basics like for the database and some are bit more unique.

User's image

Oury Ba-MSFT 19,581 Reputation points Microsoft Employee

2024-08-30T16:06:06.9266667+00:00

@Jonathan Brotto Thank you for reaching out.

Are you looking for a description of the icon in the picture above.? If yes, what icons? the black cylinder represent the databases.
Jonathan Brotto 420 Reputation points

2024-08-30T16:12:41.12+00:00

@Oury Ba-MSFT I am looking the in the picture and as I am writing queries.

Accepted answer

MikeyQiaoMSFT-0444 3,190 Reputation points

2024-09-02T01:44:35.1866667+00:00
Hi，Jonathan Brotto

Folder Icon:

Visible after expanding the database icon, used for grouping and organizing various object types within databases and instances.

For example, the database folder contains tables, views, stored procedures, security, etc.

The folder icons under an instance are used to organize and group different categories of database objects and server settings, including: Databases、Security、Server Objects、Replication、Management、SQL Server Agent.

Database Icon:

Will see all the objects in this database, such as tables, views, stored procedures, functions,etc.

Regards

Mikey Qiao

If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.
Please sign in to rate this answer.
Jonathan Brotto 420 Reputation points

2024-09-03T13:25:26.9966667+00:00

@MikeyQiaoMSFT-0444 @ how about the various icons that popup with intellisense?

MikeyQiaoMSFT-0444 3,190 Reputation points

2024-09-05T03:13:11.12+00:00

@Jonathan Brotto

This article introduces the functions of IntelliSense, and the icons in the screenshot also represent some of its features.

IntelliSense (SQL Server Management Studio)

MikeyQiaoMSFT-0444 3,190 Reputation points

2024-09-06T08:24:55.51+00:00

Hello，Jonathan Brotto,

may I ask if the answer provided has solved your issue? If you are satisfied with the answer, don't forget to "Accept it," as this will help other friends who have similar problems.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

1 additional answer

Olaf Helper 45,096 Reputation points

2024-08-30T18:21:00.3533333+00:00

some are bit more unique.

Your post ist very unclear and the screenshot is cutoff; don't know what you mean?

Do you mean the two "folder" icons? That are "folder" icons; expand the tree nodes to see the content.

One is for DB snapshots and one for system databases.
Please sign in to rate this answer.
Jonathan Brotto 420 Reputation points

2024-09-03T13:24:13.9533333+00:00

@Olaf Helper I am also looking at IntelliSense icons next to tables, and columns as I type the script.

Olaf Helper 45,096 Reputation points

2024-09-05T05:03:32.63+00:00

Still unclear what you mean.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Icons in SQL management studio

1 additional answer

Your answer