/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

5 votes242 views1 answer
Get table columns from sql
SQL
0 vote215 views1 answer
Mysql get date diff in months
SQL
0 vote220 views2 answers
How to list all values of a column that start with a letter in sql
SQL
3 votes208 views3 answers
Raw select laravel
SQL
1 vote200 views1 answer
Simple project for database
SQL
0 vote239 views1 answer
How to add mysql to path on termin after installation
SQL
3 votes199 views1 answer
Postgresql db owner change
SQL
8 votes213 views3 answers
Postgres connection string
SQL
4 votes335 views1 answer
Oracle table statistics
SQL
8 votes189 views1 answer
Unique vs primary key
SQL