Hello all,
As of today, we can easily copy or duplicate a table with in-database tool.This is really useful when you want to have data in development environment coming from production environment.
But can we for real ?
Short answer : no, we can't do it in these cases :
-partitions
-statistics
-index
-any constraints such as primary-foreign keys
But even if these ideas would be implemented, this means manually setting these parameters.
So my proposition is simply a "clone table"' tool that would clone the table from the show create table statement and just allow to specify the destination path (base.table)
![simonaubert_bd_0-1680504054872.png simonaubert_bd_0-1680504054872.png](https://community.alteryx.com/t5/image/serverpage/image-id/296730i8698A5BC121A72AB/image-size/medium?v=v2&px=400)
Best regards,
Simon