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?

4 comments
Comment actions Permalink

Could you provide an example? For me it's not clear what's wrong.

0
Comment actions Permalink

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.

 

 

0
Comment actions Permalink

same question! I need to copy the original ddl in DDL preview window to avoid comments loss!

0
Comment actions Permalink

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

0

Please sign in to leave a comment.