/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 vote245 views1 answer
Procedures sql insert mysql
SQL
1 vote216 views3 answers
Mysql Server Start
SQL
0 vote254 views1 answer
Python list from sql
SQL
0 vote266 views1 answer
Mysql collation portugues brasil
SQL
0 vote228 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
3 votes233 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
0 vote231 views1 answer
Import sql inside hide sql
SQL
0 vote247 views1 answer
Automated psql csv export script on windows
SQL
0 vote222 views1 answer
Oracle job class
SQL
4 votes315 views2 answers
Delete all table oracle
SQL