Page 1 of 1
alter table is creating table
Posted: Tue 20 Jan 2009 11:01
by 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
Re: alter table is creating table
Posted: Tue 20 Jan 2009 12:04
by Duke
jkuiper wrote: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?
Posted: Tue 20 Jan 2009 12:40
by 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?
Posted: Tue 20 Jan 2009 13:24
by Duke
When you need to save modifications, don't go to Text tab, just click Save button or press Ctrl+S.
Posted: Wed 21 Jan 2009 08:22
by jkuiper
Oke, I have to read the manual more carefully
Maybe an option to put a button with a text 'execute' on the form.
