Harry,

In additional to Nigel's suggestion, you can use TRUNCATE TABLE [TableName]. This command deletes all records and reset the Identity Key of the table, which DELETE command only deltes all records.

HTH.

Wan

>want to zap a table on sql server
>In line with MSDN's topic
>have tried
>
>SQLPREPARE(gnhandle,'Delete from vizkeys','')
>SQLEXEC(gnhandle)
>
>which doesn't report any error but doensn't delete anything either.
>
>variations like "Delete from vizkeys where realkey<>'.NULL.'" (which should delete all) don't work either.
>
>Whats the secret?