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
How do you debug a procedure in sql server?
difference between Clustered index and non clustered index ?
What is data set in report?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
What is a partition function in sql server?
How to rename databases in ms sql server?
What do you mean by acid?
How you would rewrite the sql query to return the customerid sorted numerically?
Write query to return all rows sql?
what's the difference between delete table and truncate table commands? : Sql server database administration
What happens when unicode strings concatenate with non-unicode strings?
What is merge statement?
Is there any difference between the primary key and unique key?
How to create an index on a view?
How you can minimize the deadlock situation?