/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 vote121 views1 answer
Select from column mysql
SQL
0 vote118 views1 answer
Pl sql round
SQL
4 votes117 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote126 views1 answer
Sql find table by name
SQL
1 vote136 views2 answers
Drop table with constraints
SQL
1 vote132 views5 answers
Postgresql difference between two dates in days
SQL
0 vote135 views1 answer
Count database access django
SQL
0 vote124 views2 answers
While mysql
SQL
0 vote119 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote120 views1 answer
Mysql multiple primary keys
SQL