By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,211 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

Alter Column command

P: n/a
several months ago I was trying to set the field size of text fields
in a table and Lyle Fairfield was nice enought to post a way using
alter column.

it was surprising since it was ALTER COLUMN f5 Text(250)
WHERE in the world can I find the a listing of the different things
that can be done with this?


Feb 22 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
WHERE in the world can I find the a listing of the different things
that can be done with this?
Did you think of asking the Access help system?

Hint: Try searching for the word 'alter'.

On Feb 22, 4:18 pm, sparks <jstal...@swbell.netwrote:
several months ago I was trying to set the field size of text fields
in a table and Lyle Fairfield was nice enought to post a way using
alter column.

it was surprising since it was ALTER COLUMN f5 Text(250)
WHERE in the world can I find the a listing of the different things
that can be done with this?

Feb 22 '07 #2

P: n/a
In article <jn********************************@4ax.com>,
js******@swbell.net says...
several months ago I was trying to set the field size of text fields
in a table and Lyle Fairfield was nice enought to post a way using
alter column.

it was surprising since it was ALTER COLUMN f5 Text(250)
WHERE in the world can I find the a listing of the different things
that can be done with this?


Fundamental Microsoft Jet SQL for Access 2000
http://msdn2.microsoft.com/en-us/library/aa140011
(office.10).aspx

Intermediate Microsoft Jet SQL for Access 2000
http://msdn2.microsoft.com/en-us/library/aa140015
(office.10).aspx

Advanced Microsoft Jet SQL for Access 2000
http://msdn2.microsoft.com/en-us/library/aa139977
(office.10).aspx
Feb 23 '07 #3

P: n/a
No I was looking for a good access reference book that covered this.
ALTER TABLE table {ADD {COLUMN field type[(size)] [NOT NULL]
[CONSTRAINT index] |
ALTER COLUMN field type[(size)] |
CONSTRAINT multifieldindex} |
DROP {COLUMN field I CONSTRAINT indexname} }

I was looking for a more detailed listing of all alter table and alter
column syntax with references to what can and can not be moded in
code.


On Thu, 22 Feb 2007 21:18:20 GMT, sparks <js******@swbell.netwrote:
>several months ago I was trying to set the field size of text fields
in a table and Lyle Fairfield was nice enought to post a way using
alter column.

it was surprising since it was ALTER COLUMN f5 Text(250)
WHERE in the world can I find the a listing of the different things
that can be done with this?
Feb 23 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.