How to drop an in-memory table in dolphindb?

91 Views Asked by At

In dolphindb,I can create an in-memory table in dolphindb like: t = table(1 2 3 as id); And I can use sql statements at it. But I don't know the right way to delete it.The function


dropTable(dbHandle, tableName)

can only drop the table in database.. And the function


drop(X, n)

can only drop some rows of the table X

2

There are 2 best solutions below

0
Irene97 On BEST ANSWER

In DolphinDB, you can use undef to release variables or function definitions from the memory. A in-memory table like: t = table(1 2 3 as id) can be deleted in this way.

1
hz.wale On

you can call the function clear!().for a example,

clear!(t)