determine column types

PHOTO EMBED

Wed May 04 2022 02:34:09 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

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
content_copyCOPY