Home » RDBMS Server » Server Utilities » Renaming column names
Renaming column names [message #70086] Wed, 10 April 2002 05:55 Go to next message
Bharathi
Messages: 6
Registered: March 2002
Junior Member
how do i rename a existing column in a table without changing the data and datatype

Report message to a moderator

Re: Renaming column names [message #70091 is a reply to message #70086] Thu, 11 April 2002 02:13 Go to previous messageGo to next message
Rashmi Prasad
Messages: 2
Registered: April 2002
Junior Member
rename oldname to newname

Report message to a moderator

Re: Renaming column names [message #70094 is a reply to message #70086] Thu, 11 April 2002 10:48 Go to previous message
Cindy
Messages: 88
Registered: November 1999
Member
Rename statement is use for renaming a table, view, sequence, or synonym not a column. However, here is some information on renaming column.

http://www.orafaq.net/faqsql.htm#RENAMECOL

Report message to a moderator

Previous Topic: SQLLoader: how to concatenate differents positions on one column
Next Topic: db copy
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 10:39:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.