Re: Column Name Change

Ok never mind I found the answer, It was a combination of these things.

What I got to work was:
SQL> alter table members
  2 rename column LastName to FirstNames;

Table altered.

SQL> alter table members
  2 rename column FirstName to LastName;

Table altered.

SQL> alter table members
  2 rename column FirstNames to FirstName;

Table altered.

Just wanted to pass along what I found.

Jeff

"Jeff B" <jeffby_at_KnoSpam.tds.net> wrote in message news:Edx4j.40630$G23.3325_at_newsreading01.news.tds.net...
> Good Morning,
>
> Is it possible to change a column name of a table after the table has been
> created? I have a table called Members that have FirstName, LastName
> columns. The problem I have is the information that got put into the
> table had the names reversed, so now all the first names are in the
> LastNamr column and all of the last names are in the FirstName columns. I
> tried Delete Members but I recieved an error about a value being shared,
> I found on one website Replace Column column_name To new_name but this
> did not work as I could not figure out how to reference which table I
> wanted to make that change in.
>
> Just kind of stuck at the moment, seems easiest thing would be just to
> cjange the column headings to match the data but I can not find a Modify
> or AlterTable command to do this?
>
> Thanks for the help,
>
> Jeff
Received on Sun Dec 02 2007 - 07:51:19 CST