Which statement can be used to rename a table?

All Questions › Category: Database › Which statement can be used to rename a table?
0 Vote Up Vote Down
Anonymous asked 3 years ago

Options:

  1. ALTER TABLE ‘<new name>’, ‘<original name>’
  2. EXEC sp_rename ‘<original name>’, ‘<new name>’
  3. EXEC sp_rename ‘<new name>’, ‘<original name>’
  4. ALTER TABLE ‘<new name>’
  5. EXEC sp_rename ‘<new name>’

  6. RENAME TABLE ‘<new name>’, ‘<original name>’

1 Answers
0 Vote Up Vote Down
Anonymous answered 3 years ago
  1. EXEC sp_rename ‘<original name>’, ‘<new name>’