Using SQL view

Question

Do I have to run the CREATE VIEW query every time I turn ON my computer or I just need to run it once and after that I can just use the SELECT query even after I shut down my compurter or close the DB manager?

Answer 1

Look, I think you misunderstood the view thing. You don't have to create views in order to select from any tables you might want. And maybe I got you wrong, so when you create views they stay in the database even if you shutdown your computer or dB manager. Of course, as long as it is committed to the database. Hope it helps but feel free to ask again!

Answer 2

I know there's no need to create a view in order to select from any tables, to me, it seem like a way make it easy to view any information in the DB that requieres a really long and annoying query, so we can create a view with the long and annoying query with the columns, joins, and all that good stuff we need and after that we just use a simple query with some simple filters; of course this will only work with a more general information from the tables.

Answer 3

Exactly. If you have big queries creating a view will definitely make things easier. :)