Interested to Buy Any Domain ? << Click Here >> for more details...
How can i change the column name.
- 13 Answers
- 23651 Views
- HCL, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is normalization of database?
Define full outer join in sql server joins?
How do I find the port number for sql server?
How to return the date part only from a sql server datetime datatype?
What happens if the update subquery returns no rows in ms sql server?
Explain primary key, foreign key and unique key?
What is wrong with sql server client libarary dll, ntwdblib.dll?
What are the different Topologies in which Replication can be configured?
What is difference between standardization and normalization?
How to insert data into an existing table?
What is explicit mode in sql server?
Does the order of columns in update statements matter?
How each E-R model constructs can be mapped to the relational model?
How to delete multiple rows with one delete statement in ms sql server?
What is difference between equi join and inner join?
