/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 vote296 views1 answer
Mysql update table from select on another table
SQL
11 votes195 views1 answer
Ddl materialized view
SQL
0 vote194 views1 answer
Sql server remove enter from string
SQL
17 votes195 views3 answers
Cast in sql server
SQL
1 vote218 views2 answers
Mysql extract number from string
SQL
1 vote207 views1 answer
Pl sql insert into table
SQL
2 votes183 views1 answer
Update with join sql server
SQL
0 vote216 views1 answer
Mysql insert into select with recursive
SQL
0 vote177 views2 answers
How to start postgresql laravel
SQL
0 vote211 views1 answer
Convert polygon to text in mysql
SQL