wood burning stoves*
The moose likes JDBC and the fly likes SQL Statement to CREATE a Table with an Autonumber field as its unique identifier Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL Statement to CREATE a Table with an Autonumber field as its unique identifier" Watch "SQL Statement to CREATE a Table with an Autonumber field as its unique identifier" New topic
Author

SQL Statement to CREATE a Table with an Autonumber field as its unique identifier

Dave Turner
Ranch Hand

Joined: Mar 13, 2001
Posts: 60
Hi,
just wondering if it is possible to create a table with an autonumber field using an SQL, statement. I am using Hypersonic SQL for my database at the moment, but im hoping to find an SQL statement that will work with any db.
Thanks
Dave
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: SQL Statement to CREATE a Table with an Autonumber field as its unique identifier
 
Similar Threads
How to INSERT with an autoincrement column
Can some one help me with Entity Beans
how do i do this urgent
getting the last inserted value
Code error