sysname and longsysname are user-defined datatypes that are distributed on the Adaptive Server installation tape and used in the system tables. The definitions are:
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.
