Java DB (Derby) Database Alter Column Size

java database derby javadb
Josh Pritchard picture Josh Pritchard · Sep 28, 2013 · Viewed 9k times · Source

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

Josh Pritchard picture Josh Pritchard · Oct 4, 2013

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

Related questions

java.lang.ClassNotFoundException Netbeans java derby

I use Netbeans, doing a java app. I created a class ConnectDB for db connetion using Java DB in netbeans. i started the server and ten conneted to db. when i run the file it produce java.lang.ClassNotFoundException: org.…

Read More
how to create table if it doesn't exist using Derby Db

I am new to apache derby and I cant seem to make work CREATE TABLE IF NOT EXISTS table1 ... as can be achieved in MySql etc. I am getting a 'Syntax error: Encountered "NOT" at line 1, column 17.', when I …

Read More
Exporting Derby database in Netbeans

I have a project with a derby database in it. I want to be able to make a backup or export the database so I can give it with the project files to my lecturer.

Read More