Change the Name of PointOfInterest Table in SQL

 

Question:

Purge Guest Table Content

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:

alter table PointOfInterest RENAME to TOURISTPOTS;


Tags:

rdbms programs | rdbms programs with output | rdbms programming languages | rdbms database program



Previous
Next Post »