/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 vote129 views1 answer
Except in sql alchemy
SQL
0 vote123 views1 answer
Mysql set boolean default value
SQL
5 votes144 views2 answers
Mysql dump mysql db cli
SQL
23 votes136 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote143 views1 answer
Gcloud sql instance list
SQL
1 vote132 views1 answer
Mysql select for update ejemplo
SQL
24 votes124 views6 answers
Replace mysql
SQL
0 vote113 views1 answer
Create schema sql server
SQL
0 vote123 views1 answer
Drop view in mysql
SQL
0 vote129 views1 answer
Find duplicate users by email address in mysql
SQL