Question:
Change the Name of PointOfInterest Table
The resort management wants to change the name “PointOfInterest” to “TOURISTSPOTS”. Write a SQL statement to fulfill the requirement.
[hint : Use alter statement to rename the table]
Code:
sample.sql
alter table PointOfInterest RENAME to TOURISTPOTS;