Edit table design (alter table?)

[nicolafarina]

Hi all,

I'm trying our new dbForge Studio Standard license and I found visual editor very useful, but I can't use it like the Management Studio for editing tables design.

First of all, I can't understand how to rename tables with a simple "rename" command; the only way I found to accomplish this is to manually edit the CREATE TABLE sql query.

Another issue is moving columns order; I can't move columns in tables having constrains/foreign keys.

I suppose that this issues are derived to the editing methodology of dbForge Studio, based on DROP and CREATE again objects. This way makes edit tables design really annoying compared to Management Studio.

Any help to clarify me this jobs or some workarounds?

Thank you.

[alexa]

First of all, I can't understand how to rename tables with a simple "rename" command; the only way I found to accomplish this is to manually edit the CREATE TABLE sql query.

Such functionality will be implemented in the next version of the product. We will notify you once this version is available for downloading.

Another issue is moving columns order; I can't move columns in tables having constrains/foreign keys.

This can be performed as follows:
1. Double-click the table in Database Explorer. The table's object editor opens.
2. Right-click the column in the column list and select 'Move Column Up' or 'Move Column Down'.
3. Once the changes are made, press 'Ctrl+S' to save the changes.

[nicolafarina]

Thanks for reply Alexa.

Can't now reproduce the columns reorder issue; as soon as found it again, I will post it.

Regards.