aspose file tools
The moose likes JDBC and Relational Databases and the fly likes What does IDENTITY mean in SQL? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Groovy Fundamentals video training course this week in the Groovy forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "What does IDENTITY mean in SQL?" Watch "What does IDENTITY mean in SQL?" New topic
Author

What does IDENTITY mean in SQL?

Namitha karupaiya
Ranch Hand

Joined: Mar 10, 2004
Posts: 89
CREATE TABLE DEMO_BLOB (
IDCOL INTEGER IDENTITY (1,1) PRIMARY KEY,
BLOBCOL BLOB)

In the above SQL command what does that IDENTITY (1,1) mean?

Thank you very much.
Martin Simons
Ranch Hand

Joined: Mar 02, 2006
Posts: 196
it seems to be a "new SQL Standard" way of saying AUTO_INCREMENT in
MySQL or creating a sequence in Oracle.

See the following:

http://www.oracle.com/technology/products/rdb/pdf/0307_identity_columns.pdf#search='SQL%20IDENTITY'
Masoud Kalali
Author
Ranch Hand

Joined: Jul 08, 2004
Posts: 531

It look to be an identity column which start from 1 and increment by 1


Masoud Kalali
Software Engineer - My Weblog - GlassFish Security
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: What does IDENTITY mean in SQL?