HOW TO RENAME A COLUMN NAME
Answers were Sorted based on User's Feedback
Answer / ravikv
SP_Rename 'dbo.table_name.column_name','new column_name'.
| Is This Answer Correct ? | 27 Yes | 4 No |
Answer / ram&saran
SP_RENAME '<table_name>.<old_column_name>','<new_column_name>'
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / praveen kumar.dandu
suppose we had a table name emp and columns ename and sal.
<sql>alter table emp rename column sal to salary;
it wll rename the column sal to salary
| Is This Answer Correct ? | 5 Yes | 12 No |
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
Is mysql the same as sql server?
What is the syntax for encrypting a column in SQL Server?
what are acid properties? : Sql server database administration
How to return the date part only from a sql server datetime datatype?
What is the difference between char and varchar2 datatype in sql?
Explain the different index configurations a table can have?
What happens to a trigger with multiple affected rows?
What is subquery in sql?
Where cross join is used?
How many levels of sp nesting are possible?
wat is the main diff between sql server 2000and sql server 2005
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)