create or alter view commandPlanned
Implement a “create or alter view” command in dvstudio. It would create the view if it doesn’t exist. Otherwise it would replace it.
Comment actionsOfficial comment
thanks for positing this feature request in our community. This extension to our SQL grammar would be useful and indeed it is already in the wish-list of other customers. I can't give you an exact estimation about when this feature will be released but I can suggest you, as a workaround, to use the combination of DROP VIEW IF EXISTS command and CREATE VIEW.
If the view doesn't exist, it will just be created by the CREATE VIEW command, otherwise it will be first dropped and then recreated with the new definition.
Please sign in to leave a comment.