/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 vote139 views1 answer
Sql not exists
SQL
0 vote130 views1 answer
C# mysql data reader from two tables
SQL
0 vote93 views4 answers
Sql limit 1 offset 1
SQL
0 vote146 views1 answer
Install sql server windows 10
SQL
0 vote146 views1 answer
How to input data as id in database sql c#
SQL
0 vote193 views1 answer
Tsql find procedure with name
SQL
0 vote133 views1 answer
Postgresql combine values in one field
SQL
0 vote167 views1 answer
Eliminate zero from integer mysql
SQL
1 vote151 views1 answer
Set statiscis on in sql server
SQL
0 vote141 views1 answer
Show tables in cassandra cql
SQL