how do you create an auto number field in Access using DDL?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do you create an auto number field in Access using DDL? the Auto things
it an Auto..!
 
KhalilS said:
how do you create an auto number field in Access using DDL? the Auto things
it an Auto..!
Click to expand...

Example:

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)
)


Sincerely,

Chris O.
 
Chris2 said:
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)
)
Click to expand...

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.

--
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Access problem 0
The next Grand Theft Auto title has been officially announced 0
Access auto numbers 3
create an Auto-increment field for use as the primary index betwee 1
Auto Fill in table 0
auto number 2
auto number primary key 4
Simple Access Project - Almost There Just Need Some Help... 2

Back
Top