/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 vote161 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote149 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote149 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
6 votes145 views1 answer
Oracle desc table primary key
SQL
0 vote149 views1 answer
Bitmap join index
SQL
1 vote177 views2 answers
Changes not showing on website server odoo
SQL
0 vote130 views1 answer
Selecting Data in SQL - Select Data
SQL
0 vote136 views1 answer
Postgresql alter column nullable
SQL
21 votes114 views7 answers
Table drop if exist sql server
SQL
4 votes186 views2 answers
Convert utc to est sql
SQL