From the course: SQL Essential Training
Join today to access over 23,200 courses taught by industry experts.
Deleting views - SQL Tutorial
From the course: SQL Essential Training
Deleting views
- [Instructor] So we've looked at creating a view, we've looked at modifying a view. Now, let's take a look at deleting it. As you may have guessed, an easy way to do this is by going to our database structure and when we right-click, it was hard not to notice the last option here which is to delete a view. And this is one of the ways that we could actually simply delete a view. Now, I could hit delete view. We do get a confirmation message and we could just simply confirm that. I'm not going to do that just yet. I'm going to hit no for now. Take a note of our view, v average total. I'm going to head over to the execute SQL tab, and show you one more way that we could actually delete a view via SQL syntax. And that is the keyword, drop. And we want to specify that we are dropping a view, so we say, view. And next, we want to simply state the view name that we would like to drop. And we want to drop our V_Avg…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.