RE: SQL type for Autoincrement field

[Alexander Liffers <alex@tmp.com.au>]

create table "tablename.db"
(
	field1 SMALLINT,
	field2 SMALLINT,
	field3 autoinc
)

This above worked in database desktop at anyrate and that uses the BDE also.

Alex Liffers
Tenera Merx Productions Pty Ltd
http://www.tmp.com

-----Original Message-----
From:	Russ Hore [SMTP:rhore@lhr-sys.DHL.COM]
Sent:	Thursday, 12 March 1998 01:16
To:	cpb-thread@zdtips.com
Subject:	SQL type for Autoincrement field

I have a problem with not being able to initialise an autoincrement 
field in one of my tables. So I have decided to drop the table and 
recreate it (I want to clear all the records anyway) using SQL.

So I do 

drop table "tablename.db";

create table "tablename.db"
(
	field1 SMALLINT,
	field2 SMALLINT,
	field3 <???>
)

where field 3 should be the autoincrement field.

My question...what is the SQL type for an autoincrement field in
Paradox tables ?