[bluesky999]

I am importing an AS400 database file to an SQL. Everything is coming over nicely problem is I need to change the Name of the filed to something more user friendly example CNTNA = Customer Name. How can I do this in SQL? Thank you for any help

[Advertisements]

Hello bluesky,
the thing you need is:

ALTER TABLE table_name CHANGE old_field_name new_field_name field_definition

This works for MySQL.

Edited by Hai Mac, 27 January 2006 - 12:27 PM.

[Hai Mac]

Hello bluesky,
the thing you need is:

ALTER TABLE table_name CHANGE old_field_name new_field_name field_definition

This works for MySQL.

Edited by Hai Mac, 27 January 2006 - 12:27 PM.

[bluesky999]

Thank you...Thank You.... I will try and let you know.... Thank you..