Changing Column Size Through ALTER TABLE SQL Statement

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

Marshall Barton

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alter Back-End Table from Front-End 5
Specifying Column Position When Using ALTER TABLE 3
Question about ALTER TABLE and ALTER COLUMN 7
Automatically generate a "create table" statement 5
Help with ALTER TABLE statement 14
Change Precision and Scale 1
alter column statement for boolen 3
Invalid Column Name Sql-Error :Executing a stored procedure 1

Top