HOW TO RENAME A COLUMN NAME

Answer Posted / ravikv

SP_Rename 'dbo.table_name.column_name','new column_name'.

Is This Answer Correct ?    27 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of locks in the database?

486


What happens if the update subquery returns multiple rows in ms sql server?

586


What are the types of indexes?

590


How to locate and take substrings with charindex() and substring() functions?

508


What is the language structure to add a record to a table?

573






How to use go command in "sqlcmd"?

642


Can sql server be linked with other servers like oracle?

519


What are the disadvantages of merge replication?

769


What are the underflow and overflow behaviors on float literals?

572


What are the ways available in sql server to execute sql statements?

565


Find first and last day of current month in sql server

595


How would you use user_constraints table in DB?

586


Where in ms sql server is ’100’ equal to ‘0’?

596


How to search for a string in all stored procedure in sql server?

533


Does transparent data encryption provide encryption when transmitting data across the network?

624