information_schema.columns.character_maximum_length

Note:

Maximum length.

Note:

For string columns, the maximum length in characters.

Note:

If data_type identifies a character or bit string type, the declared maximum length; null for all other data types or if no maximum length was declared.

Note:

If data_type identifies a character or bit string type, the declared maximum length; null for all other data types or if no maximum length was declared.

Note:

If data_type is STRING, the maximum length in characters of a value; otherwise NULL.

Note:

If DATA_TYPE is STRING, the maximum length in characters of a value; otherwise NULL.

Note:

Maximum length, in characters, for binary data, character data, or text and image data. -1 for xml and large-value type data. Otherwise, NULL is returned. For more information, see Data Types (Transact-SQL).