SYSNAME is a built-in data type limited to 128 Unicode characters, which is primarily used to store object names in SQL Server. It is basically the same as using nvarchar (128) NOT NULL. Although it is SQL Server data type we cannot use this data type to create a column with it. This data type is not listed in the data-type list which comes when creating tables via table designer. By Default, SYSNAME is NOT NULL. All data type are stored on SYS.TYPES table. See below.
