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).

What database are you using? MySQL? PostgreSQL? SQL Server? Derby? Something else? — Luke Woodward
– Luke Woodward, Commented Sep 28, 2013 at 11:35
JDBC is just a tunnel between your code and the database so you need your SQL to be valid for the particular database you are using. — Thorbjørn Ravn Andersen
– Thorbjørn Ravn Andersen, Commented Sep 28, 2013 at 19:34
Java DB used to be called (and perhaps is still referenced as ) Derby — Brian Agnew
– Brian Agnew, Commented Apr 7, 2016 at 9:01

Brian Agnew · Accepted Answer · 2016-04-07 09:02:07Z

8

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];

edited Apr 7, 2016 at 9:02

Brian Agnew

273k38 gold badges342 silver badges443 bronze badges

answered Oct 4, 2013 at 14:59

Josh Pritchard

1411 gold badge1 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

SpringLearner · Accepted Answer · 2013-09-28 12:03:53Z

1

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)

edited Sep 28, 2013 at 12:03

answered Sep 28, 2013 at 9:57

SpringLearner

13.9k20 gold badges82 silver badges117 bronze badges

2 Comments

Brian Agnew Over a year ago

Does this work with JavaDb (aka Derby?). I don't believe it does

SpringLearner Over a year ago

@BrianAgnew I am not sure about Derby. This was very old question and at that time tags were java,database,netbeans and jdbc

Collectives™ on Stack Overflow

Java DB (Derby) Database Alter Column Size

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related