Question:
Why doesn’t the datatype called sysname show up in all the tables’ dropdown lists of datatypes?
Answer:
The sysname datatype is a system datatype used to store database object names such as table columns, variables and stored procedure parameters. This is a user-defined datatype based on the nvarchar datatype and is used only in system tables, which is why you don’t see it when you are creating table columns.