/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 vote114 views1 answer
Can sqldatareader be null
SQL
2 votes150 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote100 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote111 views1 answer
How to select a row in sql
SQL
10 votes113 views2 answers
Show tables in schema oracle
SQL
2 votes107 views3 answers
How to get second highest salary in each department in sql
SQL
3 votes139 views1 answer
Mysql cli connect with password
SQL
13 votes102 views5 answers
Oracle list tables
SQL
9 votes111 views1 answer
Oracle get table schema
SQL
0 vote118 views1 answer
Remove transient options sql wordpress
SQL