🔍
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)