/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 vote124 views1 answer
Sql server express download
SQL
1 vote78 views1 answer
Mssql string length
SQL
0 vote135 views1 answer
Mysql update set sum
SQL
31 votes128 views3 answers
SQL Server change column data type
SQL
0 vote228 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
5 votes137 views1 answer
Mysql count newlines in field
SQL
7 votes142 views1 answer
Sql limit decimal places
SQL
1 vote118 views2 answers
Mssql show database size
SQL
0 vote132 views1 answer
Mysql sum with group by
SQL
0 vote154 views1 answer
Sql to excel pgadmin
SQL