Why does #MSSQLServer allow table indexes that have no name? How are they created? What is their use?

#dba #ssms #microsoft