Chris2 wrote:
CREATE TABLE Policies
(policy_id AUTOINCREMENT
,policy_start_date DATETIME
,policy_renewal_date DATETIME
,premium_payable CURRENCY
,other_policy_details TEXT(255)
,CONSTRAINT pk_Policies PRIMARY KEY (policy_id)
)


FWIW I prefer the synonym IDENTITY i.e. the same for SQL Server. Also,
you can explicitly specify the data type plus the seed and increment
values e.g. could make your column definition clearer with:

policy_id INTEGER IDENTITY (1,1) NOT NULL

Jamie.

--