Rename View syntax
RENAME view_name TO new_view_name;
| COURSE_ID | NAME | DESCRIPTION | DURATION | PRICE |
|---|---|---|---|---|
| 2 | SQL 2 | SQL course for advanced | 2 week | 50 |
| 4 | PHP | PHP course | 4 week | 75 |
| 5 | CSS | Learn CSS | 2 week | 20 |
Rename View example
rename course_view to test_view;
select * from test_view;
Output:
| COURSE_ID | NAME | DESCRIPTION | DURATION | PRICE |
|---|---|---|---|---|
| 2 | SQL 2 | SQL course for advanced | 2 week | 50 |
| 4 | PHP | PHP course | 4 week | 75 |
| 5 | CSS | Learn CSS | 2 week | 20 |