/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 vote196 views2 answers
Mysql insert into multiple tables
SQL
-1 vote173 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
1 vote253 views1 answer
Mysql connect command
SQL
0 vote261 views1 answer
Last date for each user sql
SQL
12 votes269 views4 answers
How to drop all tables in postgresql
SQL
0 vote184 views1 answer
Mysql backup certain tables workbench
SQL
0 vote223 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
4 votes313 views1 answer
What are the data types
SQL
0 vote188 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote177 views2 answers
Sqlite unix timestamp
SQL