/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 votes137 views2 answers
Sql server port number
SQL
0 vote126 views1 answer
Like sql for second letter of the family name
SQL
0 vote138 views1 answer
Kill slow queries mysql
SQL
4 votes135 views4 answers
Sqlite describe table
SQL
0 vote150 views1 answer
What does the -p flag do in mysql cli
SQL
10 votes87 views2 answers
Django mysql
SQL
11 votes144 views2 answers
Sql rank
SQL
4 votes140 views2 answers
Error loading MySQLdb module.
SQL
0 vote194 views1 answer
Get last inserted primary key
SQL
0 vote121 views1 answer
Drop all tables in azure sql database
SQL