ALTER TABLE TEST2 RENAME NEWFIELD2 TO NEWCOLUMN

I am trying to rename a column in a query, but it fails wth the following error:

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'NEWFIELD2'.

I also noted that in SQL Query Analyzer that the colour coding of the query indicates that RENAME isn't a correct command (ie: not shown in blue)

I also had the same problem when I tried to rename a whole table.

Any advice?

Regards,

Sean Anderson

__________________
Regards,

Sean Anderson

Hii seananderson!!
Hope this will help you
http://p2p.wrox.com/topic.asp?TOPIC_ID=15190

Other Articles
http://msdn2.microsoft.com/en-US/library/ms188351.aspx
http://www.functionx.com/sqlserver/Lesson05b.htm
http://databases.aspfaq.com/database...-a-column.html

Cheers :)

vinod

to rename

for eg chenge column name for fnmae to fname in table employee

step 1 rename employee to employe
step 2 create table employee (fname,lname , and other columns of table) as select * from employe.

then drop employe
and add constraints againn to employee if any exist.

alter table do not change name of column , table and size of column if table data exist