SQLTableRemove - cDbUpdateFunctionLibrary

Deletes a SQL table.

Parameters: Integer hTable

Parameter	Description
hTable	A file handle to the table name. Same as the Filelist.cfg slot number. Note: There is also a "SqlTableRemoveByTableName" function where you instead of the filelist number pass the table name as a string.

Syntax

Function SQLTableRemove hTable

Call:

Send SQLTableRemove SysTable.File_Number

Description

Use it to remove a whole table. The file handle is the same as the file number in Filelist.cfg.

Note: It will remove the table with all data at the SQL back end and from filelist.cfg as well as it removes the .int file from disk.

Example

Procedure OnUpdate

Boolean bOK

Get SQLTableRemove MyOldTable.File_Number

End_Procedure