bill201
asked on
how to change a table column name on access with an alter query
hi
i have a table that the name is "table1" and there is a field with the name "field2" and i want to change it to the name "field1" how can i make it, something like this:
ALTER TABLe table1
ALTER COLUMN field2 field1
thanks alot
i have a table that the name is "table1" and there is a field with the name "field2" and i want to change it to the name "field1" how can i make it, something like this:
ALTER TABLe table1
ALTER COLUMN field2 field1
thanks alot
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You are welcome!
/gustav
/gustav
ASKER