Subject Re: [firebird-support] What type to use for primary key?
Author Martijn Tonies
Hi,

> I am designing big database, where will be one generator that will
> generate values for primary keys of all tables (so all records in all
> tables will be unique). Integer is too small for primary key I decided
> to use NUMERIC(15,1). Will it slow down performace? What is
> generator's max size? What type to use?

Use NUMERIC(18, 0)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com