Maximum column name length in SQL Server 2005

I was asked about this problem today and I could find it neither in SQL Server documentation nor online, so I checked it experimentally.

The name
is invalid because it is empty, contains invalid characters, or contains
more than 128 characters.

Maximum allowed column name length in SQL Server 2005 is 128 characters.


As phorku wrote in his comment, the maximum column name length can also be determined by checking properties of the sysname data type:
sysname is a system-supplied user-defined data type that is functionally equivalent to nvarchar(128) and is used to reference database object names

1 comment:

  1. Check out the user defined datatype sysname...