
SELECT SysCat.Tables.TabName, SysCat.Tables.Create_Time,
COUNT(SysCat.Columns.TypeName) 
FROM SysCat.Columns, SysCat.Tables 
WHERE
SysCat.Tables.TabSchema = SysCat.Columns.TabSchema 
AND SysCat.Tables.TabName = SysCat.Columns.Tabname 
AND SysCat.Columns.TypeName = 'DECIMAL' 
GROUP BY
SysCat.Tables.TabName, SysCat.Tables.Create_Time;