Table Data

These functions let you fetch table information.

rigDbListTables()

Returns an array containing the names of all the tables in the database you are currently connected to. Example:

put rigDbListTables() into tTables

repeat for each key tKey in tTables
  put tTables[tKey] & comma after tTableslist
end repeat

rigDbTableExists()

Sometimes it's helpful to know whether a particular table exists before running an operation on it. Returns a boolean TRUE/FALSE. Usage example:

if rigDbTableExists("tablename") is TRUE then
  -- some code...
end if

Note: Replace tablename with the name of the table you are looking for.