MS Access alter data length

Tech

Registered User.
Local time
Today, 15:45
Joined
Oct 31, 2002
Messages
267
what would the T-SQL be for changing (altering) the data length of a field programmatically in a table in MS Access?
so if a field had a data length of 50, id like to change this to 60 programmatically. What would the code/syntax be?
 
found it

ALTER TABLE [TableName] ALTER COLUMN [ColumnName] DataType(size)
 

Users who are viewing this thread

Back
Top Bottom