How can i change the column name.
Answers were Sorted based on User's Feedback
Answer / durgaprasad
sp_rename 'tablename.oldcolumnname','newcolumnname'
Is This Answer Correct ? | 31 Yes | 3 No |
Answer / kinthada cnu
hi all
sp_rename 'tablename.oldcolumnname','newcolumnname','column'
Is This Answer Correct ? | 18 Yes | 4 No |
Answer / ramesh5782
ALTER TABLE table_name
RENAME COLUMN old_name to new_name;
Is This Answer Correct ? | 22 Yes | 17 No |
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.
Is This Answer Correct ? | 4 Yes | 0 No |
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'
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / naren
update tablename set newcolumn name where old column name
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / dipti sonawane
alter table (table_name)
change (old_colomnname)(new_colomnname)
Is This Answer Correct ? | 0 Yes | 0 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
What is the default fill factor value?
What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.
What are the different types of columns types constraints in the sql server?
Who developed sql server?
What is the optimization being performed in oracle and SQL Server?
You want to implement the one-to-many relationship while designing tables. How would you do it?
how to retrive only second row from table in sql server 2000?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
why would you call update statistics? : Sql server database administration
how to copy only distinct data into another table which is not already exist in database?
1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?
what are user defined datatypes? : Sql server database administration