/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 vote148 views1 answer
Create temporal table in sql
SQL
0 vote227 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote145 views1 answer
Cross apply top for each row t1
SQL
2 votes161 views1 answer
Drop sequence
SQL
0 vote176 views1 answer
Permission denied postgres \copy csv command line
SQL
4 votes168 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote171 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote144 views1 answer
Commit transaction sql
SQL
1 vote175 views2 answers
Sql select only row with the max date
SQL
-1 vote148 views1 answer
How to check table exists or not in postgresql
SQL