/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

31 votes238 views2 answers
Grant all priviledges to mysql user
SQL
0 vote267 views1 answer
Sql show founctions
SQL
2 votes228 views1 answer
How to add where command in update comand with joins
SQL
0 vote220 views1 answer
Sql auto_increment syntax
SQL
0 vote256 views1 answer
Wp_query raw sql
SQL
0 vote239 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
1 vote253 views1 answer
Postgresql append array
SQL
17 votes228 views3 answers
How to change a collumn name in sql
SQL
2 votes235 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote250 views1 answer
View t-sql mail configuration
SQL