/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

1 vote449 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
1 vote384 views1 answer
Table information in sql server
SQL
3 votes364 views3 answers
Mysql order by list
SQL
1 vote355 views1 answer
Get last week data in mysql
SQL
3 votes341 views1 answer
Sql cast to integer
SQL
1 vote403 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote374 views1 answer
Difference between 2 query results sql server
SQL
3 votes362 views2 answers
Monthname sql
SQL
0 vote356 views1 answer
Add multiple field in table sql
SQL
0 vote385 views1 answer
SQL-Arten
SQL