Hi

EDB ..last... Delphi last....


i have in a table a ID Field GENERATED

COLUMN "ID" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1,
INCREMENT BY 1) NOT NULL

add 100 records, i have ID value from 1 to 100,

when i make a DELETE FROM MyTable , ( zap table )
this value is not reseted, if i add a record ID value is 101 , but i want 1.

How i can reset the generated value ( saved in internal structure of table )
?

now.. i delete fisical file... but i'm looking a query mode

Mauro


From an earlier post by Uli Becker in the sql newsgroup

Have a look here:

http://tinyurl.com/2v3m788


Roy Lambert [Team Elevate]

Mauro,


ALTER TABLE "MyTable" ALTER COLUMN ID RESTART WITH 0


--
Fernando Dias
[Team Elevate]

Tnx at all.


> ALTER TABLE "MyTable" ALTER COLUMN ID RESTART WITH 0

is there a method without EXCLUSIVE access ?

Mauro,

Not that I am aware of, and it wouldn't be safe to do such a change and not having the table locked.

--
Fernando Dias
[Team Elevate]

Mauro,

<< when i make a DELETE FROM MyTable , ( zap table ) >>

If you're always deleting all of the rows from the table, then the EMPTY
TABLE statement will both delete all of the rows and reset all IDENTITY
columns back to 0:

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=EMPTY_TABLE

--
Tim Young
Elevate Software
www.elevatesoft.com