/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 vote224 views1 answer
Oracle for loop on list
SQL
10 votes227 views2 answers
Sql pagination offset
SQL
0 vote217 views1 answer
How to find username and password in oracle 18c
SQL
0 vote223 views1 answer
Jdbc sql connection string
SQL
4 votes215 views2 answers
Mysql select where starts with
SQL
2 votes228 views1 answer
Orcale index size
SQL
0 vote224 views1 answer
Why we have to set the password for my sql server
SQL
0 vote212 views1 answer
Sql contains numeric characters
SQL
8 votes232 views1 answer
Ltrim sql
SQL
0 vote223 views2 answers
How to check if sqlite table exists in nodejs
SQL