Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Truncate table 1

Status
Not open for further replies.
zemp

zemp

Programmer
Jan 27, 2002
3,301
CA
Pervasive 8.6 and 9

MS SQL Server has a 'Truncate Table..' SQL statement that will remove all date from the table and reset the PK identity field to '1'(the starting value).

Does Pervasive have a similar statement/keyword? If so what is the synatx? If not how can I acheive the same effect in Pervasive?

I have searched the Pervasive site forums and knowledge base with no luck.

zemp
 
Sort by date Sort by votes
THere is no truncate command.
One way you can do it is delete all records using "delete from <table>". That will also reset the Identity field.
If this is in an application, you could drop the table and recreate it as well.



Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
 
Upvote 0 Downvote
That's what I needed, thanks.

zemp
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Ino Mart
  • Locked
  • Question
How to use a variable as table name in a procedure 1
Replies
2
Views
248
Ino Mart
Ino Mart
michellepace
  • Locked
  • Question
Basic SQL: Add column to select statement (ie value from another table)
Replies
1
Views
229
michellepace
michellepace
bojimuncher
  • Locked
  • Question
Linking tables crashing Pervasive 1
Replies
7
Views
282
mirtheil
mirtheil
soocallmebrady
  • Locked
  • Question
Pervasive SQL Update with Joins - Error: Unknown table or correlation name
Replies
0
Views
146
soocallmebrady
soocallmebrady
Pete Halaczkiewicz
  • Locked
  • Question
Open table not returning all rows
Replies
1
Views
131
mirtheil
mirtheil

Part and Inventory Search

Sponsor

Back
Top