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.

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

0 Answers   TCS,

What is difference between join and natural join?

0 Answers  

What are the new features in SQL Server 2005?

3 Answers   Emphasis,

How to fetch the next row from a cursor with a "fetch" statement?

0 Answers  

Relational calculus is what type of language?

0 Answers   HCL,

List out a number of the wants to setup a SQL Server failover cluster?

0 Answers  

How to enter binary string literals in ms sql server?

0 Answers  

Explain about Joins?

0 Answers   Infosys,

Which are the important points to note when multilanguage data is stored in a table?

0 Answers  

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  

How are the exceptions handled in sql server programming?

0 Answers  

What is Index Segmentation ?

1 Answers   TCS,