I have encountered a couple of issues in the sections explaining the cloning of tables without constraints, copying all rows, and recreating constraints using creation DDL statements. I believe these areas could benefit from additional clarity and completeness.
The area where I found some confusion is related to the statement:
A better way is to list out the constraint definitions as creation DDL statements. This makes for straightforward copy-and-paste to recreate them.
While the book does an excellent job explaining how to handle each constraint, sequence, and index individually, it does not provide a cohesive example of create an equivalent constraint on the destination table using the definition from the source table using creation DDL statements.
Including a comprehensive example that demonstrates the steps involved in extracting constraint definitions and applying them to the destination table would be extremely beneficial.
I appreciate your attention to these points and believe that addressing them will significantly enhance the clarity and usefulness of your book for readers.
Best regards,
Viktor