/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 vote285 views1 answer
Oracle lower in where clause
SQL
0 vote260 views1 answer
List MySQL Table and Index Size
SQL
0 vote259 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote287 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
1 vote297 views2 answers
Mysql extract number from string
SQL
4 votes347 views2 answers
Delete all table oracle
SQL
13 votes286 views3 answers
Insert mysql ifile nto database
SQL
0 vote293 views1 answer
Oracle current date minus 1 day
SQL
-1 vote303 views1 answer
Add 10 to all numbers in a column sql
SQL
9 votes268 views6 answers
Sql add column with default value
SQL