PDA

View Full Version : how to add a field to an existing table using sql statement in MS Access


zyklone
August 20th, 2004, 02:14 AM
how to add a field to an existing table using sql statement in MS Access
amitgeorge
August 20th, 2004, 04:15 AM
ALTER TABLE <<tablename>> ADD COLUMN <<newfieldname>> TEXT(25);

see

http://www.blueclaw-db.com/alter_table_ddl.htm

for more info.