Toad World® Forums

How to change column width field


#1

Hello,

We have a table called ‘Test’ and one of the columns named ‘Change’ currently is set up as VARCHAR2 (32 Byte)…we need to change the size of this specific column (double in size) so what script can we use in Toad to make this happen?

Any help would be greatly appreciated

Thanks


#2
  1. Find the table in the schema browser.
  2. Double-click the table
  3. Change the size of the column in the dialog that appears.
  4. Click Show SQL to see the command to make the change, or click OK to just do it.

#3

Here is the SQL:

alter table test modify (change varchar2(64));

Cheers,
Russ


#4

Thanks John…it works[:)]


#5

Thanks Russell…I tried this method as well and it works