/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

2 votes282 views1 answer
Postgresql drop primary key constraint
SQL
0 vote283 views1 answer
Mysql changer nom table
SQL
0 vote304 views1 answer
Mysql select random rows large table
SQL
2 votes290 views1 answer
How to find constraints on a table in oracle
SQL
0 vote289 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote304 views1 answer
Create a sql server database programmatically
SQL
3 votes271 views1 answer
Show index table
SQL
0 vote299 views1 answer
Select lowest values sql
SQL
0 vote280 views1 answer
Can sqldatareader be null
SQL
0 vote296 views1 answer
Sql developer search all packages for text
SQL