select 
column_name,
data_type
from
information_schema.columns
where table_name = (column_name)

--this will run a query to determine the types of each table data type