/SQL/Distinct data types in a table sql query

Distinct data types in a table sql query

select table_name, count(*)
from 
	(select distinct data_type as data_type, table_name 
	 FROM information_schema.columns
	WHERE table_name like '<table-name>') t
group by table_name

Similar codes

0 vote315 views1 answer
Power bi dax add related shows column but not working
SQL
4 votes319 views1 answer
Sql query to make a existing column auto increment
SQL
1 vote350 views1 answer
Where not in array sql
SQL
0 vote318 views1 answer
Output table plsql
SQL
0 vote349 views2 answers
SQL FROM
SQL
3 votes364 views1 answer
Laravel paginate raw sql
SQL
1 vote304 views1 answer
Autocommit mysql
SQL
1 vote339 views1 answer
Mysql get domain from url
SQL
5 votes329 views1 answer
Commentaire table oracle
SQL
1 vote345 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL