select colname,
             case mod(coltype,256)
                WHEN  0 THEN "CHAR"
                WHEN  1 THEN "SMALLINT"
                WHEN  2 THEN "INTEGER"
                WHEN  3 THEN "FLOAT"
                WHEN  4 THEN "SMALLFLOAT"
                WHEN  5 THEN "DECIMAL"
                WHEN  6 THEN "SERIAL"
                WHEN  7 THEN "DATE"
                WHEN  8 THEN "MONEY"
                WHEN  9 THEN "NULL"
                WHEN 10 THEN "DATETIME"
                WHEN 11 THEN "BYTE"
                WHEN 12 THEN "TEXT"
                WHEN 13 THEN "VARCHAR"
                WHEN 14 THEN "INTERVAL"
                WHEN 15 THEN "NCHAR"
                WHEN 16 THEN "NVCHAR"
                WHEN 17 THEN "INT8"
                WHEN 18 THEN "SERIAL8"
                WHEN 19 THEN "SET"
                WHEN 20 THEN "MULTISET"
                WHEN 21 THEN "LIST"
                WHEN 22 THEN "rOW (unnamed)"
                WHEN 23 THEN "COLLECTION"
                WHEN 24 THEN "ROWREF"
                WHEN 25 THEN "rOW (unnamed)"
                WHEN 40 THEN "Variable-length opaque type"
                WHEN 41 THEN "Fixed-length opaque type"
                WHEN 4118 THEN "Named row type"
                ELSE "UNKNOWN"
              END coltype,
              CASE
                WHEN mod(coltype,256) in (5,8) THEN trunc(collength/256)||","||mod(collength,256)
                WHEN mod(coltype,256) in (10,14) THEN
                   CASE trunc(mod(collength,256)/16)
                        WHEN  0 THEN "YEAR"
                        WHEN  2 THEN "MONTH"
                        WHEN  4 THEN "DAY"
                        WHEN  6 THEN "HOUR"
                        WHEN  8 THEN "MINUTE"
                        WHEN 10 THEN "SECOND"
                        WHEN 11 THEN "FRACTION(1)"
                        WHEN 12 THEN "FRACTION(2)"
                        WHEN 13 THEN "FRACTION(3)"
                        WHEN 14 THEN "FRACTION(4)"
                        WHEN 15 THEN "FRACTION(5)"
                     END ||"("||trunc(collength/256)+trunc(mod(collength,256)/16)-mod(collength,16)||") : "||
                       CASE mod(collength,16)
                        WHEN  0 THEN "YEAR"
                        WHEN  2 THEN "MONTH"
                        WHEN  4 THEN "DAY"
                        WHEN  6 THEN "HOUR"
                        WHEN  8 THEN "MINUTE"
                        WHEN 10 THEN "SECOND"
                        WHEN 11 THEN "FRACTION(1)"
                        WHEN 12 THEN "FRACTION(2)"
                        WHEN 13 THEN "FRACTION(3)"
                        WHEN 14 THEN "FRACTION(4)"
                        WHEN 15 THEN "FRACTION(5)"
                     END
                 ELSE ""||collength
          END collength,
              CASE
                    WHEN coltype>255 THEN "Нет"
                    ELSE "Да" END nnull,
                    colno
                                from syscolumns
                                where tabid=:tabid
order by colno