SQL

Use To Find The Data Type Of Column In Table For Sql


Try this

select column_name, data_type, character_maximum_length from information_schema.columns
where table_name like '%TableName%'