A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
What does IDENTITY mean in SQL?
Joined: Mar 10, 2004
Mar 03, 2006 02:32:00
CREATE TABLE DEMO_BLOB (
IDCOL INTEGER IDENTITY (1,1) PRIMARY KEY,
In the above SQL command what does that IDENTITY (1,1) mean?
Thank you very much.
Joined: Mar 02, 2006
Mar 03, 2006 02:55:00
it seems to be a "new SQL Standard" way of saying AUTO_INCREMENT in
MySQL or creating a sequence in Oracle.
See the following:
Joined: Jul 08, 2004
Mar 03, 2006 09:43:00
It look to be an identity column which start from 1 and increment by 1
Software Engineer -
subject: What does IDENTITY mean in SQL?
Seating arrangement application in JSP/Struts
Session Bean Identity
org.hibernate.MappingException: No Dialect mapping for JDBC type: -9
Run-as security identity functionality
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014