/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 vote199 views1 answer
How to export only procedures mysql
SQL
0 vote188 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote211 views1 answer
Sql find table by name
SQL
5 votes228 views1 answer
Oracle nls instance
SQL
0 vote192 views1 answer
Postgres create database if not exists
SQL
-1 vote231 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
5 votes218 views2 answers
Oracle list columns
SQL
1 vote212 views1 answer
How to check the mysql version mac
SQL
2 votes367 views1 answer
How to create sql database
SQL
0 vote210 views1 answer
Postgres can integer fields be negative
SQL