Which statement can be used to rename a table?
Options:
- ALTER TABLE ‘<new name>’, ‘<original name>’
- EXEC sp_rename ‘<original name>’, ‘<new name>’
- EXEC sp_rename ‘<new name>’, ‘<original name>’
- ALTER TABLE ‘<new name>’
- EXEC sp_rename ‘<new name>’
-
RENAME TABLE ‘<new name>’, ‘<original name>’