use d:\mydbf
>select distinct * from mydbf into c:\temp

select distinct * from mydbf into TABLE c:\temp