/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 votes360 views3 answers
Sql server utc to local
SQL
0 vote320 views1 answer
Oracle exchange partition
SQL
0 vote327 views1 answer
Convert int to varchar sql
SQL
0 vote273 views1 answer
Oracle sql developer script output limit
SQL
0 vote324 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
13 votes307 views4 answers
Mysql get last row
SQL
13 votes347 views2 answers
Get date from now() mysql
SQL
2 votes314 views1 answer
Import large .sql files into lampp
SQL
0 vote320 views1 answer
Drop a field in psql django
SQL
0 vote332 views1 answer
Longtext sql
SQL