I tried to find out, for each of the column, the type of it and the length of it for all tables
select distinct COLUMN_TYPE, DATA_TYPE, table_name, CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH, NUMERIC_PRECISION, numeric_scale
WHERE TABLE_SCHEMA = '<Database>' and DATA_TYPE= 'int'
order by table_name
but it seems that only the int type DO NOT have the length indicated by how long is the INT type.
By wanting to know the HOW LONG is the int field type, like int (10) , int (4) and so on, which table should I look for?
it is funny that only INT type don't record the type but I don't believe, there must be a table store this information but I can't see why !!
Or please suggest what should I do to change the query about to display how long is the int type.
I will change the query to a bit different than the above to check all column's type and length of a table one by one:
select COLUMN_NAME,COLUMN_TYPE, IS_NULLABLE, Column_default, COLUMN_COMMENT,
DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH, NUMERIC_PRECISION, numeric_scale
WHERE TABLE_SCHEMA = '<database>' AND TABLE_NAME = '<table>' ;