/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

0 vote165 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote182 views1 answer
Savepoint mysql script
SQL
0 vote183 views1 answer
Mysql set variable to today's date
SQL
50 votes195 views6 answers
Install mysql on ubuntu
SQL
1 vote169 views1 answer
Calculate age in sql postgresql
SQL
0 vote173 views1 answer
Désinstaller postgresql linux
SQL
0 vote172 views1 answer
Initcap in mysql
SQL
0 vote162 views1 answer
Mysql:5.6 syntax create table
SQL
1 vote175 views1 answer
How do you use sql in you company
SQL
11 votes177 views3 answers
Change column name sql server management studio
SQL