DROP TABLE mytable
CREATE TABLE myTable (
Col1 INTEGER,
Col2 AUTOINCREMENT,
Col3 YESNO,
Col4 TEXT (50)
)
-----Original Message-----
From: Nick Baker [mailto:[EMAIL PROTECTED]
Sent: Monday, 1 March 2004 2:19 p.m.
To: CF-Talk
Subject: Can you reset row numbers in a DB after deleting all rows?
MS Access
CF 5
Can you reset rows numbers back to starting at row number 1 in a DB, after
deleting all rows?
The goal is to totally erase and restore DB, on the fly, from time to time.
New info will have the same columns, but a different number of rows each
time. The Delete Row function of a CFQUERY will do this, but the new row
number starts where the delete row numbers left off. We will eventually run
out of row numbers.
Or is there another way to do this, e.g., delete and regenerate the table
anew on the fly?
Thanks,
Nick
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
