/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

1 vote237 views1 answer
Oracle check table lock
SQL
11 votes192 views1 answer
Sql query to find duplicates in column
SQL
0 vote182 views1 answer
Java sql insert return id
SQL
0 vote143 views0 answer
SQL
7 votes186 views2 answers
What is sql clause
SQL
0 vote185 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
4 votes181 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote182 views1 answer
Char vs varchar2 in sql
SQL
0 vote200 views1 answer
What is top n result in sql
SQL
10 votes219 views4 answers
Join multiple tables in sql
SQL