Create databases where you need them.
Data can be deleted from a table using the standard SQL DELETE syntax:
DELETE FROM myTable
This DELETE statement will delete all rows in the table. Note that unlike the DROP DATABASE command, deleted data is not archived and backed up. Therefore, when data is deleted in DBLX it is gone forever.
When using the DELETE TABLE command, it is recommended to use a WHERE clause to specify the records to be deleted:
DELETE FROM myTable WHERE columnTwo = 'col2Value'
The WHERE CLAUSE in a SQL statement supports equals
'=', not equals
'<>', greater than
'>', less than
'<', greater than or equal
'>=', less than or equal
NOT LIKE comparators.
DBLX has one limitation when using the SQL WHERE clause:
ORin a WHERE clause will be evaluated from left to right.
DBLX is delivered with some system tables. These system tables do not allow DELETE statements to be executed.