Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Feature Request: Auto Copy Alter Table Sql To Clipboard

forums forums SQLyog SQLyog: Bugs / Feature Requests Feature Request: Auto Copy Alter Table Sql To Clipboard

  • This topic is empty.
Viewing 2 reply threads
  • Author
    • #13554

      I find myself in the following pattern frequently:

      1. Use the table properties window to make some structure change to a table
      2. Switch to the History tab
      3. Find the ALTER TABLE statement that was generated for that structure change
      4. Select the SQL
      5. Copy the SQL to the clipboard
      6. Navigate to other windows for different mysql servers, paste in the SQL and execute it.

      It would be nice if steps 2 – 5 could be combined into step 1.  Perhaps a checkbox down near the “Save” button on table properties that would automatically copy the SQL to the clipboard when the save button is clicked. Or a button that becomes enabled after the Save is done to copy the SQL to the clipboard. I would not want this as a preferences options, because I can see turning it off/on frequently.

    • #35757
      Sibin A S

      Hello Mitch,


      All the changes that you make to the table from ‘Alter Table’ option can be viewed in the query format even before committing/saving the changes in the ‘SQL Preview’ tab. You may either save or revert the changes made to the table also. You may refer the below image,


      SQL Preview.png


      Instead, you may also use the ‘Schema Synchronization Tool’ to sync the changes in the table structure.




    • #35758

      Thank you for that information.


      I still believe that my request has merit and hope that it will be considered.

Viewing 2 reply threads
  • You must be logged in to reply to this topic.