Previous Topic: -163 - MORE THAN 1 DEFAULT SPECIFIED FOR A COLUMNNext Topic: -165 - DUPLICATE CONSTRAINT NAME: nnnnnnnn mmmmmmmm

SQL Codes › SQL Return Codes -1 through -999 › -164 - CHARACTER DEFAULT MORE THAN 20 BYTES

-164 - CHARACTER DEFAULT MORE THAN 20 BYTES

Explanation

You have specified a default value of more than 20 bytes.

The SQLSTATE that equates to this SQL return code is 54S02.

User Response

Change the default value to 20 bytes or less.