InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:20:25 GMT20http://www.teradata.com/teradataforum/Topic11779-9-1.aspxThank you. That works fine.Thu, 12 Jun 2008 16:05:23 GMTywjcjjhttp://www.teradata.com/teradataforum/Topic11779-9-1.aspxyou can do an ALTER TABLE mytbl RENAME COLUMN oldnme TO newnme;However there are restrictions, like you can't rename a column if it's part of an index (for PI you will have to drop and recreate the table, for SI, drop indexes and then rename, create the SI again ...)For the complete list of restrictions, lookup the "Renaming Table Columns" section in data definitions manual.Thu, 12 Jun 2008 14:46:45 GMTjoedsilvahttp://www.teradata.com/teradataforum/Topic11779-9-1.aspxIf i want to change column name from 'ABC' to 'ABCD', what is the easiest way to do it. and if the column is one of the primary index, how could i do it?Mon, 09 Jun 2008 17:56:27 GMTywjcjj