Press "Enter" to skip to content

sysname and Default Nullability

Kenneth Fisher discovers a secret of the sysname datatype:

The other day I was creating a table to store some metadata. Since the metadata I was collecting (sys.databases.name for example) uses the datatype sysname I used the same datatype. In case you didn’t know sysname is an nvarchar(128) user defined datatype used in a number of the system views.

Click through for Kenneth’s finding.