I can get column table information with this command, but that don't return column
SELECT COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'tableName'
SQL has a LEN() Function. Which will give you a length so could try something like:
SELECT COLUMN_NAME, LENGTH(COLUMN_NAME) as Column Length, DATA_TYPE, LENGTH(DATA_TYPE) as Data Length ...
Hope that helps