Answer / durgaprasad

sp_rename 'tablename.oldcolumnname','newcolumnname'

Answer / kinthada cnu

hi all

sp_rename 'tablename.oldcolumnname','newcolumnname','column'

Answer / ramesh5782

ALTER TABLE table_name
RENAME COLUMN old_name to new_name;

Answer / harsh v m

Sonia, clear your doubt here.

AS keyword is used for aliasing some existing column name
for our convenience.But the column name doesn't change @
database.

But incase of renaming a column the change is reflected @
database n it's usually done if we wish changing property
of a particular column.

sp_rename 'tablename.oldcolumnname','newcolumnname'->This
actually works out for Sql 2000.ALTER TABLE key doesn't
help.

Answer / sanjay

ALTER TABLE tablename CHANGE oldname newname varchar (10) ;

Answer / y.narendra kumar

This example renames the contact title column in the
customers table to title.

EXEC sp_rename 'customers.[contact
title]', 'title', 'COLUMN'

Answer / naren

update tablename set newcolumn name where old column name

Answer / dipti sonawane

alter table (table_name)
change (old_colomnname)(new_colomnname)

Answer / om

the alter command is used to do modification at column level . so in order to change the name of a column we need to use alter .

command:- alter table (table name) rename (old column name) to (new column name)
note :- dont put brackets its just for u to understand

Answer / sonia

hi frnds, tell me one thing what is the difference b/w AS
keyword & sp_rename,AS is also used for reanme operation na.

What do you mean by data manipulation language?

1 Answers  

How do I find the default sql server instance?

1 Answers  

What is Right Outer Join?

2 Answers  

What are the acid properties?

1 Answers  

Is candidate a key?

1 Answers  

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

What is the difference between varchar and nvarchar types?

1 Answers  

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1 Answers  

Can two tables share the same primary key?

1 Answers  

How to encrypt data between dialogs?

1 Answers  

What protocol does sql server use?

1 Answers  

What are the different methods available under sqlcommand class to access the data?

1 Answers   UGC Corporation,