Import/Export -> Copy Table to... Why is the DDL statement not the original statement
已完成
If I copy table A to XX DB table A, will the comments, default values, and indexes of DDL statements not be synchronized?
请先登录再写评论。
Could you provide an example? For me it's not clear what's wrong.
Hello, operation process:
The above operation uses copying table data to another DB. I would ideally copy the source table structure, as well as the table structure, other descriptions, and default values.
same question! I need to copy the original ddl in DDL preview window to avoid comments loss!
I see, as a workaround you can recreate table structure manually and then copy data with Copy Table To action.
Also, upvote the issue https://youtrack.jetbrains.com/issue/DBE-5944/Copying-tables-inside-the-same-DBs-should-copy-more-stuff