Removes a materialized view from the HFSQL server.
// Create a materialized view on a server
IF NOT HUpdateView(MyConnection1, MyMaterializedView) THEN
Trace(HErrorInfo())
END
// Refresh the materialized view on the server
IF NOT HRefreshView(MyConnection1, MyMaterializedView) THEN
Trace(HErrorInfo())
END
// Remove the materialized view from the server
IF NOT HDropView(MyConnection1, MyMaterializedView) THEN
Trace(HErrorInfo())
END
Syntax
<Result> = HDropView(<Connection> , <View> [, <Cascading deletion>])
<Result>: Boolean
- True if the operation was performed,
- False if a problem occurs. HErrorInfo is used to identify the error.
<Connection>: Character string or Connection variable
Connection to the HFSQL server that contains the materialized view. This connection corresponds to:
<View>: Character string
Name of the materialized view to handle (present on the server).
<Cascading deletion>: Optional boolean
- True to enable cascading deletion,
- False (default value) otherwise.
Remarks
If the materialized view does not exist, the function returns a non-fatal error.
Business / UI classification: Business Logic