create or alter view command

Planned

Follow

0

Gary Tucker

• September 19, 2018 14:12

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 actions Permalink

  Official comment

  

  Salvatore Raunich

  • September 19, 2018 17:15

  Hi Gary,

  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.

  Best regards

  Salvatore

Please sign in to leave a comment.