I’ve created a backup of my table and with this backup I’m able to recreate my table again. The idea was to delete the old ‚PRUEFEN‘ table and create a new one by recreating the old table.
First of all you’ll be able to backup your table by right clicking it and execute the ‚Grab Structure…‘ command. A save-dialog will pop up and there you can choose a place to save your table structure.
No you will be able to grab this structure of your old table and recreate a new one by right clicking the Table folder und select the ‚Recreate Table…‘ button. Of course you have to rename your table if you haven’t deleted the old ‚PRUEFEN‘ table to something like ‚PRUFENNEW‘.
This will open up a new diaolog with the CREATE TABLE statement. Now by clicking the ‚Edit table script‘ button you will be able to change your column name. If you have already forgotten… that’s why I’ve started to write this tutorial 😉
Have you recognized the table script in the above picture? Where have all the foreign keys gone? Hmmmmmm…. So now I have the same work as yesterday. Hopefully in the final release this problem will be solved. I changed my table script so all my requirements are implemented and that is what it looks like:
Finished! No…. I’ve forgotton the PERSNR foreign key. Damn it! But I have to do the whole work again anyway because I don’t want to have the ‚…NEW‘ in my table’s name. Ahhhh ;o)
Finally: My Script and my Table view