/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

3 votes397 views1 answer
Oracle cannot access v$session
SQL
0 vote296 views1 answer
Connexion mysql
SQL
3 votes302 views2 answers
Install mysql powershell
SQL
1 vote302 views1 answer
Get table column names sql ssms
SQL
0 vote304 views1 answer
How to see password mysql vestacp
SQL
0 vote295 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote317 views1 answer
Sql server alter table add column tinyint
SQL
0 vote299 views1 answer
Greater than or equal to symbol in postgres
SQL
1 vote286 views1 answer
Real world example of nosql
SQL
0 vote301 views1 answer
Sql count matching group by
SQL