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 |
What are transactions and its controls?
SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
Explain about the command-line tool SQLCMD?
How do I create an extended event in sql server?
What does null mean?
What are the types of subquery?
What is oltp (online transaction processing)?
Is Sql non procedural query language?
Can we store videos inside the sql server table?
What are .mdf files?
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)