Missing Sysname Index

Question

When I used SQL Server Management Studio to display an evaluation plan for query execution, it sometimes suggests a missing index.

My question is about sysname in the following sentence: what does sysname mean?

I would just simply replace the first line of CREATE NONCLUSTERED INDEX [IX_Users_Surname], so I don’t understand the link to sysname.

CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>] ON [dbo].[Users] ([Surname]) INCLUDE ([UserID],[Firstname],[Email],[Password]) 

Answer 1

The syntax <name, type> intended for the dialog for replacing SSMS templates, see Replace template parameters :

To use this dialog box, you must have parameters in the script enclosed in angle brackets (<>) in the format <parameter_name, data_type, default_value> .

Therefore, sysname is the parameter type of the index name template, and sysname is the corresponding type.