SQLViewRemove - cDbUpdateFunctionLibrary

Deletes a SQL view.


Note: If you want to create a data view it is suggested to use an embedded script. Then use the SQLIncludeScriptFile command and the SqlUtilExecuteResource function to call & execute the embedded script file.


Type: Function


Parameters: String sViewName

Parameter

Description

sViewName

The name of the SQL data view.


Syntax


Procedure SQLViewRemvoe sTableName

Call:

Send SQLViewRemove "MyDataView"



Description

Use it to remove a data view.

Note: There is no API  as this is particular for SQL databases.


Example


Procedure OnUpdate

    Boolean bOK

   

    Get SQLViewRemove "MyDataView"


End_Procedure