Is it possible to save a view in the database as table? | Sololearn: Learn to code for FREE!
Nouvelle formation ! Tous les codeurs devraient apprendre l'IA générative !
Essayez une leçon gratuite
0

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

29th Nov 2016, 3:19 PM
arjel
arjel - avatar
3 Réponses
+ 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