/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

-1 vote334 views2 answers
Sql truncate number
SQL
1 vote349 views1 answer
Backup mysql schema only
SQL
1 vote302 views1 answer
Display total number of tables in mysql
SQL
0 vote335 views1 answer
Mysql query with sql to get the next row
SQL
0 vote365 views1 answer
Min varias colunas spark sql
SQL
0 vote318 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote302 views1 answer
Remove default constraint sql server
SQL
1 vote328 views1 answer
Search for replace in mysql
SQL
2 votes320 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote320 views1 answer
Find and replace database table phpmyadmin
SQL