-users@sqlite.org
Subject: Re: [sqlite] How to truncate table?
Date: Wed, 20 Jul 2005 00:40:33 -0500
On Jul 20, 2005, at 12:33 AM, chan wilson wrote:
Hi Puneet Kishor ,
Yes, you are right. I have to check out whether "DELETE FROM
table;" will really set the auto imcrement primary key
baz');
sqlite> select * from t;
1|qux
2|baz
sqlite>
From: Puneet Kishor <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] How to truncate table?
Date: Wed, 20 Jul 2005 00:29:27 -0500
On Jul 19, 2005, at 11:50 PM, chan wils
Hi Puneet Kishor ,
Yes, you are right. I have to check out whether "DELETE FROM table;" will
really set the auto imcrement primary key seed back zero.
From: Puneet Kishor <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
Subject: Re: [sqlite]
On Jul 19, 2005, at 11:50 PM, chan wilson wrote:
Hi,
In MS SQL, there is a "TRUNCATE TABLE" SQL that will remove all the
records of a table and make the identity back to zero.
Is there any means to accomplish it in sqlite?
How about
DELETE FROM table;
I am assuming, by 'identity'
4 matches
Mail list logo