How to rename a table using sql queries?

  • Interview Candidate
  • 2
  • 1718

Showing Answers 1 - 2 of 2 Answers

BalaSM

  • Aug 2nd, 2006
 

hi

This done by

exec sp_rename 'oldTableName' , 'newTableName'

  Was this answer useful?  Yes

Raj

  • Dec 8th, 2006
 

It is actually

sp_rename <old object name>, <new object name>, <object type>.

It changes the name of a user-created object (for example, table, column, or user-defined data type) in the current database.ype) in the current database.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions