/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 vote345 views2 answers
Sql update multiple tables
SQL
0 vote349 views1 answer
Convert excel into sqllite db using python
SQL
17 votes311 views2 answers
How to assign date field for table in mysql
SQL
0 vote354 views1 answer
Shows all databases created by user in ms sql
SQL
4 votes374 views1 answer
Rename stored procedure in sql server
SQL
0 vote345 views1 answer
Connexion mysql
SQL
10 votes351 views4 answers
Drop primary key
SQL
1 vote339 views1 answer
Mysql current time
SQL
25 votes338 views6 answers
Sql update query
SQL
0 vote337 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL