🔍

Table meta-information

To get table fields, use monadic ! verb:

o)a:(+:)`a`b`c!(1 2 3;1 2 3;1 2 3); !a
`a`b`c
o)

Asking for table "values" results in a list of table vectors:

o)a:(+:)`a`b`c!(1 2 3;1 2 3;1 2 3); value a
1 2 3
1 2 3
1 2 3
o)

Every table can be queried for its length - the amount of "records" it contains:

o)a:(+:)`a`b`c!(1 2 3 4;1 2 3 4;1 2 3 4); #a
4
o)

Designated meta verb rеturns column names, types, internal typed ids, attributes and list of fielsds of composite index for a table:

o)t:(+:)`a`b`c!(`asc#!5;`g#!5;!5); @[`t;,,`a;~[#];`g];
o)meta t
+`column`type`id`attr!(`a`b`c;`long`long`long;176448 438592 45376;`asc`g`)
(,`a)

<<< prev Indexing
next >>> Arithmetics