データ型

• Oracle

int
char
varchar2
date

 
select data_type,count(*)
from dba_tab_columns
where owner= 'TEST'
group by data_type
order by data_type
;

• MySQL

https://dev.mysql.com/doc/refman/5.6/ja/data-type-overview.html

int
char
varchar
datetime

create table tab11(col1 int,col2 char(100),col3 varchar(100),col4 datetime);

select data_type,count(*)
from information_schema.columns
where table_schema='test'
group by data_type
order by data_type
;

• PostgreSQL

int
char
varchar
timestamp

select data_type,count(*)
from information_schema.columns
where table_catalog='test'
group by data_type
order by data_type
;

• SQL Server

int
char
varchar
datetime2

select data_type,count(*)
from information_schema.columns
where table_catalog='test'
group by data_type
order by data_type
;