7 hours 36 minutes
I welcome back to Module three sequel programming. This is less than four table expressions, and this will be a quick lesson. We're in sub lesson 4.4 c t e with a view,
and what we're going to do is take the comment table expressions that we generated in the last lesson, and we're going to put them behind a virtual table known as a view. And that's really simple and easy to dio create or replace.
S O. What the state middle dues will create the view if it doesn't exist, or it will replace the view. If it does exist, let's go ahead and run that
and it ran. Let's go ahead and refresh our views. Folder and D Beaver.
So right Click, refresh
and get rid of this filter if you have it in there.
Roided strength of tables
there's the manager and folk. We give that a double click.
We can see the columns that we created.
Take a look at the source code, which, if you weren't familiar with what we were doing, this would look pretty complicated. You'll also see that Ah
de Beaver or my seat. The my sequel engine has changed the way that the quarry looks, and it's not as reliable as it used to be.
There's the data tab and the yard E. R. Diagram. Now, if we want to use this
as a table in the future in different queries to make even more complicated connections of data, it will be much easier to deal with because it will be in a view. And we won't have to really worry about
the source that is creating that view, and that completes this lesson again. It was a short lesson. It was just
combining two ideas, which was taking a common table expression chain and putting it behind of you to make it more manageable for future queries. So I hope you enjoy this lesson and I will see you in the next one. Thank you.