-----Original Message-----
From: Frank Ingermann [mailto:frank.ingermann@...]
Sent: 12 June 2001 20:37
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] ato increment / IDENTITY

>Hi Bernhard,

>>programmer@... wrote:
>> how to set up a field in a table that is to be used as primary key.
>> In MS SQL Server there is the IDENTITY keyword in MySQL there is auto
>> increment. What is in InterBase?

-----------------
stuff snipped
-----------------

>btw. if you're using IB6, define the pk columns as NUMERIC(18,0) - that's
>because generators have grown from 32bit (=INTEGER) in IB5.6 to 64bit in
>IB6 - unfortunately there is no INT64 sql type in IB6, but NUMERIC(18,0)
>*is* actually a 64bit int.

Don't define the pk columns bigger than you need to. If they're used as FK's
in other tables you'll be wasting a lot of space if you use 8 bytes when 2
or 4 will do.

>hth,
>fingerman

Ray Drew
CIA UK


[Non-text portions of this message have been removed]