createView should support having the entire view definition in the change body

Description

When generating createView changes from an existing database, there can be crazy SQL used to generate the view originally that comes through in the view definition, but the getViewDefinition method isn't smart enough to figure out what parts need to be stripped out to allow later adding of "create view".

Perhaps modify the CreateViewGenerator to not include the "create/replace/alter view" statement if it detects it is already in.

Perhaps add a "contains entire SQL" flag to createView so nothing is added to the passed SQL.

Environment

All

Reporter

Nathan Voxland

Fix versions

Affects versions

Priority

Major
Configure