alter table is creating table

[jkuiper]

If I want to alter a table, dbForge studio is actually creating a script that's create a new table and not modifying it. The problem with creating an existing table, all my data is lost.

I'm using dbForge studio standard 3.10.22

[Duke]

If I want to alter a table, dbForge studio is actually creating a script that's create a new table and not modifying it. The problem with creating an existing table, all my data is lost.

Application does modify existing table and not recreate it.
Did you try to save modified table or just saw CREATE TABLE statement on Text view of the table editor?

[jkuiper]

If I want to modify a table, I go to to the design tab with clicking on the popupmenu 'edit table'. There I will modify the table. In Design tab I don't see an option to put all modifications to the databaseserver. Therefore I go to the text tab. This window shows this

Code: Select all

CREATE TABLE test.gebruiker(
  id INT (10) UNSIGNED NOT NULL AUTO_INCREMENT,
  naamvoluit VARCHAR (45) NOT NULL,
  PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 5
CHARACTER SET latin1
COLLATE latin1_swedish_ci;

In this window I can with ALT+F5 execute the SQL. But this is a CREATE and not an ALTER. I only modified the field naam into naamvoluit.

Is there another way to accomplish this?

[Duke]

When you need to save modifications, don't go to Text tab, just click Save button or press Ctrl+S.

[jkuiper]

Oke, I have to read the manual more carefully

Maybe an option to put a button with a text 'execute' on the form.