This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Change column size Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Change column size" Watch "Change column size" New topic
Author

Change column size

Joel Christophel
Ranch Hand

Joined: Apr 20, 2011
Posts: 249
    
    1

How would I go about changnig the size/length of a column? (e.g. 25 characters)
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 20078
    
  30

Use the ALTER [table_name] ALTER COLUMN [column_name] command.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6 - OCEJPAD 6
How To Ask Questions How To Answer Questions
 
Have you checked out Aspose?
 
subject: Change column size
 
jQuery in Action, 3rd edition