Is it possible to save a view in the database as table? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Is it possible to save a view in the database as table?

29th Nov 2016, 3:19 PM
arjel
arjel - avatar
3 Answers
+ 1
why not
29th Nov 2016, 4:12 PM
Saeed
Saeed - avatar
+ 1
One of the questions refers to the fact that we don't need any physical space to create a view and this confused me a bit... Could you explain how the whole thing works, please? Is there a specific way to save the view as a new table?
29th Nov 2016, 4:16 PM
arjel
arjel - avatar
0
the view is like a virtual table dynamicaly created by SQL at the time the user runs the sql query. It can be queried then the same way as a normal table
18th Jan 2017, 1:42 PM
Greg Oboroceanu
Greg Oboroceanu - avatar