/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 vote169 views1 answer
Mysql value ends with
SQL
3 votes161 views1 answer
Oracle cannot access v$session
SQL
41 votes228 views6 answers
Alter table add column in SQL Server
SQL
0 vote155 views1 answer
Nosql vs sql
SQL
1 vote160 views1 answer
Oracle create index if not exists
SQL
1 vote146 views4 answers
Postgres extract date from timestamp
SQL
0 vote148 views1 answer
Initcap in mysql
SQL
0 vote153 views1 answer
Mysql server not running
SQL
0 vote134 views1 answer
How to find unique key in sql
SQL
1 vote151 views2 answers
Snowflake alter column data type
SQL