sysname and longsysname are user-defined datatypes that are distributed on the SAP ASE installation media and used in the system tables.
sysname – varchar(30) "not null"
longsysname – varchar(255) "not null"
You can declare a column, parameter, or variable to be of types sysname and longsysname. Alternately, you can also create a user-defined datatype with a base type of sysname and longsysname, and then define columns, parameters, and variables with the user-defined datatype.
All user-defined datatypes, including sysname and longsysname, are Transact-SQL extensions.