What is wrong with my sql command?
select Table_Name, column_name + ' ' + Upper(data_type) + ' ' +
CASE
When data_type = bigint then '4'
WHEN data_type = char then Cast(character_maximum_length As varchar(10))
ELSE 'Whatever'
END 'Columns'
from information_schema.columns
