/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

1 vote161 views1 answer
Select random sample sql
SQL
5 votes187 views1 answer
Mysql add user with all privileges
SQL
4 votes192 views3 answers
Sql drop database if exists
SQL
1 vote180 views1 answer
How to select department from table
SQL
0 vote178 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
8 votes270 views2 answers
Select current_timestamp - interval '3 days';
SQL
11 votes191 views3 answers
Sql line numbers
SQL
0 vote172 views1 answer
Online sql testing tool
SQL
0 vote193 views1 answer
Sql find all different values in column
SQL
0 vote200 views1 answer
Run sql script file and changes db name in this file using c#
SQL