Import/Export -> Copy Table to... Why is the DDL statement not the original statement
Completed
If I copy table A to XX DB table A, will the comments, default values, and indexes of DDL statements not be synchronized?
Please sign in to leave a comment.
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