/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

65 votes533 views6 answers
Sql add column to table
SQL
0 vote191 views1 answer
Oracle last connexion
SQL
0 vote168 views1 answer
Array aggre distinct postgres
SQL
52 votes811 views6 answers
Rename column sql
SQL
0 vote250 views1 answer
Mysql loop through databases and execute query
SQL
3 votes193 views2 answers
How to delete git repo locally
SQL
0 vote182 views1 answer
Sql ignore
SQL
0 vote195 views1 answer
Drop table BigQuery table columns
SQL
0 vote196 views1 answer
Sql create and grant user access to database
SQL
0 vote214 views1 answer
Select 1 from orders
SQL