Icons in SQL management studio

Question

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

Answer 1

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.

Answer 2

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.