Hello Christoph,

> how can I recognize the difference between bigint and numeric() in
> rdb$fields.rdb$field_type? Both come with numeric value 16!?
> Everybody knows, that there is a difference, and in DBW e.G., the
> texts 'BigInt' and 'Numeric(x,xx)' are shown.

Internally, a large NUMERIC is an INT64.

If there's a "precision", Database Workbench knows this
was defined as NUMERIC instead of plain BIGINT.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com