Is it possible to modify/alter views?


After a view has been created, is there a way to update/modify its definition?
Or would it need to be deleted & recreated?


Drop and create; I have no clues on databases you can alter views


I’ve come across it before.

For example:


Looks like a gym nic; the drop and create a of a logical statement takes just milliseconds