0

Working on a SQLite database, seems DbVisualizer Pro does a lot of work very well, except one,

Changing table schema.

I often need to change column name, data type, etc, but don't want to do it through raw SQL statement. My workaround is opening Firefox's SQLite Manager to just change the schema.

enter image description here

Is it possible to use DbVisualizer to change the schema? many thanks!

Edit: Alter table action mentioned below by roger, seems to be the right way to go. But somehow I can only add column, the existing column appears to be read only.

enter image description here

Mine is DBVisualizer Pro Evaluation. Is non-Evaluation different?

enter image description here

Edit2: Using SQLite Manager is sometimes dangerous, as warned below. just learned, renaming a column may cause the foreign key loss. but workaround is here

enter image description here

Community
  • 1
  • 1
Rm558
  • 4,621
  • 3
  • 38
  • 43

1 Answers1

0

In DbVisualizer Pro there is the Alter Table action (and Create Table for creating new tables). Select the actual table you want to change in the Databases tab, right-click and chose Alter Table. In order for this to work you need DbVisualizer Pro and the Database Type for your connection must be set to either Auto Detect (recommended) or SQLite.

roger
  • 641
  • 4
  • 7
  • Renaming columns are not supported by SQLite and that is why the names are read-only in DbVisualizer. – roger Jan 10 '16 at 07:09