Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auto Increment field!

Status
Not open for further replies.
nowayout

nowayout

Programmer
Joined
Feb 25, 2003
Messages
364
Location
US
Hi all,

How can i change the field to make it increment automatically. such as ID field to auto increment for each entry.

Thanks
 
Sort by date Sort by votes
Change the field type to identity.
 
Upvote 0 Downvote
there is no choice in EM when creating new table!!
 
Upvote 0 Downvote
There is an Ident data type. You can look it up in books online and read how it works.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question Question
Field types question
Replies
9
Views
955
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question Question
Adding field duplicates records
Replies
16
Views
944
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question Question
Adding Text to and XML Field
Replies
2
Views
437
grnzbra
grnzbra
eboughey1008
  • Locked
  • Question Question
Import columns from one table into another table with dissimilar field layout
Replies
7
Views
647
Chris Miller
Chris Miller
JD5241
  • Locked
  • Question Question
SQL Field - check for specific count of characters
Replies
2
Views
448
JD5241
JD5241

Part and Inventory Search

Sponsor

Back
Top