AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Thursday, August 23, 2012

Extending text field with SQL

If you need to change field type in Access table – you have to add new field, copy data from old field to new one, delete old and rename new to old. But if field type remains the same and you only need to increase field size – you can do this with simple SQL statement:

ALTER TABLE Customers
ALTER COLUMN CompanyName VARCHAR(50)

Labels: ,

0 Comments:

Post a Comment

Links to this post:

Create a Link

<< Home