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: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets