Java DB (Derby) Database Alter Column Size

Question

I'm trying to alter the size of a field in my Java DB Database. I just can't seem to do it. My current data type is varchar(50) and I want to update it to varchar(150).

Answer 1

Solved:

ALTER TABLE [table] ALTER COLUMN [column] SET DATA TYPE [type];

I wasn't using the SET DATA TYPE function and was instead just trying to redeclare it by using ALTER COLUMN [column] [type];

Answer 2

For mysql you can do this way

alter table table_name modify col_name varchar(150)

JDBC codes

PreparedStatement pt =connection.prepareStatement("alter table table_name modify col_name varchar(150)");
pt.executeUpdate();

In ms sql server use this command

ALTER TABLE [table_name]
ALTER COLUMN [Column_name] varchar(150)