Rename table --rename table statement
Use the "rename table" statement to change the table name.
rename table table name before change to table name after change;
This is a sample of "rename table" to change the table name.
rename table book to author;