>Hi Friends!
>
>How can I delete all duplicate records from a table?
>
>TIA

Depends on how do you define a duplicate. ie:If only all fields match considered as duplicate :

select * from myTable ;
union ;
select * from myTable ;
into cursor crsUnique nofilter

select myTable
zap
append from dbf('crsUnique')

Cetin