How di I set a counter as an primary key ?

[Mohsan Khan [EMAIL PROTECTED]]

Hi

I want to set the "id" as an COUNTER PRIMARY KEY, how do I do that ?


stmt.executeUpdate( "CREATE TABLE " + companyName + " (id
COUNTER,fnamn TEXT(50),enamn TEXT(50),alder LONG NOT NULL,kon
TEXT(50),adress TEXT(50),postnr TEXT(50),stad TEXT(50),land
TEXT(50))" );





thanx

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html