How can i change the column name.
Answers were Sorted based on User's Feedback
Answer / vikneswaran
cannot change column name
but can change size of the data type
| Is This Answer Correct ? | 1 Yes | 4 No |
Answer / desh deepak
sp_rename 'tablename.oldcolumnname',tablenamename.newcolumnn
ame
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / kshirsagar sambhaji
ALTER TABLE table_name
RENAME COLUMN old_name to new_name;
| Is This Answer Correct ? | 3 Yes | 11 No |
How can we use ConnectorJ JDBC Driver with MS SQL?
What is the exact numeric data type in sql?
What do you understand by a view?
Explain about protocol layer present in SQL server?
What is meant by Active-Passive and Active-Active clustering setup?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
What is a domain constraint give an example?
What is difference between commit and rollback when used in transactions?
What is oltp (online transaction processing)?
What are the steps you should follow to start sql server in single-user mode?
What are the authentication modes in sql server? How can it be changed?
what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?
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)