Changing Column Size Through ALTER TABLE SQL Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to increase the size of a a MS Access database column by using
the ALTER TABLE SQL statement? I need to programatically increase the size
of a text column by executing a SQL statement. If not, does anyone have any
suggestions on doing this? I could add a new larger column to the table, but
I do not know of a way to rename a column once it is created.
I appreciate any suggestions anyone can offer.
 
Eric said:
Is there a way to increase the size of a a MS Access database column by using
the ALTER TABLE SQL statement? I need to programatically increase the size
of a text column by executing a SQL statement. If not, does anyone have any
suggestions on doing this? I could add a new larger column to the table, but
I do not know of a way to rename a column once it is created.
Click to expand...


Does your version of Access have the statement:

Alter Table tbl Alter Column fld Text(123)

Check the DDL section of the MS Jet SQL Reference in Help's
TOC.
 
Marshall:
Worked like a charm!
Thank you!!

Marshall Barton said:
Does your version of Access have the statement:

Alter Table tbl Alter Column fld Text(123)

Check the DDL section of the MS Jet SQL Reference in Help's
TOC.
Click to expand...
 
Back
Top