How do I delete a function in namespace .z?

The usual way to delete a function – any entity, for that matter, is

delete entity from namespace


delete foo from `.

However, .z is a special namespace, so delete doesn’t work:

q).z.ts: {47}
q)delete ts from `.z

There is a special command just for removing elements from .z:

q)\x .z.pi

See \x (expunge).

How do I delete a column from a table?

The delete command works for that, too. To remove a column named xyz from table t, use

delete xyz from `t // in place delete (backquote)
delete xyz from t  // returns a copy minus column xyz

How do I delete the nth row from a table?

Use delete and the virtual column i:

delete from `t where i = n

Don’t forget the backquote if you intend to delete-in-place.

This work is licensed under a Creative Commons License.
The views and opinions expressed herein are those of the authors and do not necessarily reflect those of any other person or legal entity.
Kdb+ is the registered trademark of Kx Systems, Inc.