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.