When editing a table’s design, depending on which database you are using or connected to, in addition to field name and type, you have one or more places for a field comment, as follows:
-
If you are using the built in HSQLDB then you have
Description. -
If you are connecting to MySQL then you have two comment fields:
DescriptionandColumn Description.
Using PHPMyAdmin I can see that Column Description is used for the official SQL field comment.
So why have both comment fields? Wouldn’t it make sense to have just Description and use it for the SQL comment?
Is there some other reason or usage that requires two comments for a field?