How can i change the column name.
- 13 Answers
- 19317 Views
- HCL, Yardi Software, I also Faced
- E-Mail Answers
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 |
What is normalization? Explain different forms of normalization?
What are user defined datatypes and when you should go for them?
Can two tables share the same primary key?
Can we rollback records deleted by a truncate statement?
3 Answers CarrizalSoft Technologies, United Healthcare,
what is nonclustered index
What is the most common type of join?
How to create a Master database in SQL server ?
What is the use of sign function?
What are a database and a data warehouse?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
Where the sql logs gets stored? : sql server database administration
Do you know what are various aggregate functions that are available?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
