/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 vote284 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
0 vote265 views1 answer
How to check if there is no database schema
SQL
1 vote297 views1 answer
Pl sql create table from another table
SQL
12 votes273 views4 answers
Mysql version
SQL
-1 vote264 views1 answer
Mysql coalesce
SQL
0 vote271 views2 answers
Postgresql get last day of month
SQL
0 vote313 views1 answer
"Hello User Name"
SQL
0 vote293 views3 answers
Fetlife
SQL
0 vote283 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
0 vote282 views1 answer
Postgresql in vs any performance
SQL