localdb » dropTables(var,tables)
Description
This command instructs Nexial to drop (delete) one or more tables in the embedded database. If one or more of the
specified tables do not exist, Nexial will ignore it and proceed with the remaining deletes. At the end of all
the deletes, Nexial issues a
VACUUM
command to rebuild database and optimize the use of disk space.
Behind the scene, Nexial generates the appropriate DDL statements an execute them through the
runSQLs(var,sqls) command. It should be no surprises that the associated output of these 2
commands are very similar.
Parameters
- var - the data variable used to store the result of dropping the specified tables.
- tables - a list of tables to drop, separated by
nexial.textDelim.
Example
Script:
Output:
