>Try COPY MyTable TO NewPath\NewTableName DATABASE OtherDB WITH CDX
>
>Be warned that you will loose some properties with this command (like primary index that will be converted to Candidate index).
>
>You might take a look at Stonefield for a better alternative.
>
>HTH
>
>>I would like to move some tables from one database to another without losing their extended properties, anyone know how?


Sylvain,
thank you for your help

Pete Kane