You can declare a column, parameter, or variable to be of type sysname. Alternately, you can also create a user-defined datatype with a base type of sysname and then define columns, parameters, and variables with the user-defined datatype.
