[benyah]

In discovery of the DB Browser, I am using Derby.

Q. Is it possible to connect to AWS RDS Aurora from MyEclipse?
Q. In MyEclipse DB Browser, in Table/Object Info, how can I add columns to an existing table?
Q. In MyEclipse DB Browser, how can I change the Column Data Type or Size?
Q. In MyEclipse DB Browser, it it possible to add columns to an already existing Table?

[support-tony]

benyah,

1. I understand that AWS RDS is compatible with MySQL, so I guess you could connect using a MySQL JDBC driver. This isn’t something we test, so I suggest you give it a go. We do provide a MySQL connection template when setting up a new database connection, so that might help define the correct URL. This external article might also give some clues. For more information on creating new DB connections in MyEclipse Database Explorer, check out this Learning Center article.
2. I’m afraid our Database Explorer doesn’t provide the capability to alter or add columns. However, you can generate the DDL (right click on the table and select Generate->DDL) and use that to build an ALTER statement with the amended column definitions or just drop the existing table and create a new one from the edited DDL.

I hope this helps, let us know if you have and more questions on using MyEclipse.

[Author]

Posts