How can i change the column name.
Answer Posted / sanjay
ALTER TABLE tablename CHANGE oldname newname varchar (10) ;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
When would you use it?
How to modify an existing user defined function?
Can two different columns be merged into single column? Show practically?
Is there any difference between primary key and unique with the not null condition?
What is field in algebra?
in the physical file layout, where should the transaction log be stored in relation to the data file?
Explain what is analysis service repository?
What security features are available for stored procedure?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What is query optimizer in sql server?
Explain contrast amongst grouped and non-bunched records?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
When is the use of update_statistics command?
What is an execution plan? When would you use it?
how can you check the level of fragmentation on a table? : Sql server administration