Drop/Delete Splay Table

Community Support
1

Hi,

What is the right way to Delete/drop a splayed table?

2

Hi,

There isn’t really a correct way of deleting a splayed table. You would need to delete all the directories for that table (in each partition if applicable), then reload the database. Or, to just delete it from memory, use

delete table from `.

Best wishes,

Meredith

3

On Wednesday, November 5, 2014 11:28:43 AM UTC, Vikas Agarwal wrote:

Hi,

What is the right way to Delete/drop a splayed table?

drop - as in drop from memory? - use Meredith’s command delete from namespace

http://www.thalesians.com/finance/index.php/Knowledge\_Base/Databases/Kdb#Dropping\_a\_table

 

delete - as in delete from disk? - you can use q’s hdel. or for simplicity use rm(unix), del(win).

hdel example…

`:./testsplay/ set (c1:10?10;c2:10?10)

f:{reverse hsym,.Q.dd’[hsym x;key hsym x]}

hdel each f`testsplay

Thanks,

Sean

4

Thanks Meredith. I deleted whole directory. Just wondering if i was doing it right ot not.

5

Thanks Sean.

I think the following code will be same as deleting whole directory.

`:./testsplay/ set (c1:10?10;c2:10?10)

f:{reverse hsym,.Q.dd’[hsym x;key hsym x]}

hdel each f`testsplay