trinodb / trino

Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
https://trino.io
Apache License 2.0
10.18k stars 2.93k forks source link

Add replace the the view DDL in "show create view" #22859

Open EliorMoz opened 1 month ago

EliorMoz commented 1 month ago

It will be handy if when running the "show create view" the DDL will contain "replace" For example :
Instead of "create view view_name as ....", "create or replace view view_name as ...." .

guyco33 commented 1 month ago

Maybe it can be implemented by having a new option in the show command, something like

SHOW CREATE OR REPLACE VIEW some_view
ebyhr commented 1 month ago

cc: @martint