You cannot declare a column, parameter, or variable to be of type sysname. It is possible, however, to create a user-defined datatype with a base type of sysname. You can then define columns, parameters, and variables with the user-defined datatype.
