/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 vote214 views1 answer
Sql select max value for each group
SQL
-1 vote209 views1 answer
Mysql #1064 error
SQL
1 vote193 views2 answers
Mysql does sentance contain word
SQL
0 vote202 views1 answer
Oracle call a function in a insert statement
SQL
0 vote227 views2 answers
How to install psql in ubuntu
SQL
2 votes193 views2 answers
Postgresql date at timezone
SQL
0 vote202 views1 answer
Sql select rows with different values in one column
SQL
0 vote202 views1 answer
H2 auto increment and unique
SQL
0 vote210 views1 answer
View to table sql
SQL
1 vote181 views1 answer
Mysql get last insert id
SQL