# Reference card

> **Note**
>
> Want a quick and handy q reference resource? Download the [q Cheat Sheet (PDF download)](../assets/q-cheat-sheet.pdf).
>
## Keywords


<table class="kx-tight" markdown><tbody markdown>
--8<-- "ref/kwds.txt"
</tbody></table>

### By category

<table class="kx-tight" markdown>
<tbody markdown>
--8<-- "ref/kwdcat.txt"
</tbody></table>

[`.Q.id`](dotq.md#id-sanitize) (sanitize),
[`.Q.res`](dotq.md#res-keywords) (reserved words)

## Operators


<table class="kx-tight" markdown>
<tr markdown>
<td markdown class="kx-glyph">[`.`](overloads.md#dot)</td><td colspan="3" markdown>[Apply](apply.md), [Index](apply.md#index), [Trap](apply.md#trap), [Amend](amend.md)</td>
<td markdown class="kx-glyph">[`@`](overloads.md#at)</td><td colspan="3" markdown>[Apply At](apply.md#apply-at-index-at), [Index At](apply.md#apply-at-index-at), [Trap At](apply.md#trap-at), [Amend At](amend.md)</td>
</tr>
<tr markdown>
<td markdown class="kx-glyph">[`$`](overloads.md#dollar)</td><td colspan="7" markdown>[Cast](cast.md), [Tok](tok.md), [Enumerate](enumerate.md), [Pad](pad.md), [`mmu`](mmu.md)</td>
</tr>
<tr markdown>
<td markdown class="kx-glyph">[`!`](overloads.md#bang)</td><td colspan="7" markdown>[Dict](dict.md), [Enkey](enkey.md), [Unkey](enkey.md#unkey), [Enumeration](enumeration.md), [Flip Splayed](flip-splayed.md), [Display](display.md), [internal](internal.md), [Update](funsql.md#update), [Delete](funsql.md#delete), [`lsq`](lsq.md)</td>
</tr>
<tr markdown>
<td markdown class="kx-glyph">[`?`](overloads.md#query)</td><td colspan="7" markdown>[Find](find.md), [Roll, Deal](deal.md), [Enum Extend](enum-extend.md), [Select](funsql.md#select), [Exec](funsql.md#exec), [Simple Exec](funsql.md#simple-exec), [Vector Conditional](vector-conditional.md)</td>
</tr>
<tr markdown>
</tr>
<tr markdown> <td markdown class="kx-glyph">`+ - * %`</td><td colspan="7" markdown>[Add](add.md), [Subtract](subtract.md), [Multiply](multiply.md), [Divide](divide.md)</td> </tr>
<tr markdown> <td markdown class="kx-glyph">`= <> ~`</td><td colspan="7" markdown>[Equals](comparison.md#six-comparison-operators), [Not Equals](comparison.md#six-comparison-operators), [Match](comparison.md#match)</td></tr>
<tr markdown>
<td markdown class="kx-glyph">`< <= >= >`</td><td colspan="7" markdown>[Less Than](comparison.md#six-comparison-operators), [Up To](comparison.md#six-comparison-operators), [At Least](comparison.md#six-comparison-operators), [Greater Than](comparison.md#six-comparison-operators)</td>
</tr>
<tr markdown> <td markdown class="kx-glyph">`| &`</td><td colspan="3" markdown>[Greater (OR)](greater.md), [Lesser, AND](lesser.md)</td> </tr>
<tr markdown>
<td markdown class="kx-glyph">[`#`](overloads.md#hash)</td><td colspan="3" markdown>[Take](take.md), [Set Attribute](set-attribute.md)</td>
<td markdown class="kx-glyph">[`_`](overloads.md#_-underscore)</td><td markdown>[Cut](cut.md), [Drop](drop.md)</td>
<td markdown class="kx-glyph">`:`</td><td markdown>[Assign](assign.md)</td>
</tr>
<tr markdown>
<td markdown class="kx-glyph">`^`</td><td colspan="3" markdown>[Fill](fill.md), [Coalesce](coalesce.md)</td>
<td markdown class="kx-glyph">`,`</td><td markdown>[Join](join.md)</td>
<td markdown class="kx-glyph">[`'`](overloads.md#quote)</td><td markdown>[Compose](compose.md)</td>
</tr>
<tr markdown> <td markdown class="kx-glyph">`0: 1: 2:`</td><td colspan="7" markdown>[File Text](file-text.md), [File Binary](file-binary.md), [Dynamic Load](dynamic-load.md)</td> </tr>
<tr markdown> <td markdown class="kx-glyph">`0 ±1 ±2 ±n`</td><td colspan="7" markdown>write to [console, stdout, stderr, handle _n_](handles.md)</td> </tr>
<tr markdown> <td markdown class="kx-glyph" colspan="6">`.: @: $: !: ?: +: -: *: %: =: ~: <: >: |: &: #: _: ^: ,:`</td><td colspan="2" markdown>[Assign through operator](assign.md#assign-through-operator)</td> </tr>
</table>

[Overloaded glyphs](overloads.md)

## [Iterators](iterators.md)


[maps](maps.md)                                                    [accumulators](accumulators.md)
[`'`](overloads.md#quote)   [Each](maps.md#each), [`each`](each.md), [Case](maps.md#case)       `/:`  [Each Right](maps.md#each-left-and-each-right)              [`/`](overloads.md#slash)  [Over](accumulators.md), [`over`](over.md)
[`':`](overloads.md#quote-colon)  [Each Parallel](maps.md#each-parallel), [`peach`](each.md)   `\:`  [Each Left](maps.md#each-left-and-each-right)               [`\`](overloads.md#backslash)  [Scan](accumulators.md), [`scan`](over.md)
[`':`](overloads.md#quote-colon)  [Each Prior](maps.md#each-prior), [`prior`](prior.md)


## [Execution control](control.md)


[.[f;x;e] Trap](apply.md#trap)          [: Return](function-notation.md#explicit-return)        [do](do.md)  [exit](exit.md)         [\$[x;y;z] Cond](cond.md)
[@[f;x;e] Trap-At](apply.md#trap)       [' Signal](signal.md)        [if](if.md)  [while](while.md)        [:[v;p1;r1;...] Pattern conditional](pattern.md#pattern-conditional)


[Debugging](../how_to/basics/debug.md)

## Other


[`   pop stack](../how_to/basics/debug.md)        [::](overloads.md#colon-colon)   [identity](identity.md)         [\x  system cmd x](syscmds.md)
[.](overloads.md#dot)   [push stack](../how_to/basics/debug.md)            [generic null](identity.md)     [\\    abort](../how_to/basics/debug.md)
                          [global amend](function-notation.md#name-scope)     \\\\   quit q
                          [set view](https://code.kx.com/q/learn/views/)         /    comment

()     [precedence](syntax.md#precedence-and-order-of-evaluation)    \[;\]  [expn block](syntax.md#conditional-evaluation-and-control-statements)       {}  [lambda](function-notation.md)       \`   symbol
(;)    [list](syntax.md#list-notation)               [argt list](syntax.md#bracket-notation)        ;   separator    \`:  filepath
(\[\]..) [table](syntax.md#table-notation)


## [Attributes](syntax.md#attributes)


**g** grouped     **p** parted     **s** sorted     **u** unique


[Set Attribute](set-attribute.md)

## Command-line options and system commands

<table markdown class="kx-tight">
<tr markdown><td markdown>[file](cmdline.md#file)</td></tr>
<tr markdown><td markdown>[`\a`](syscmds.md#a-tables)</td><td markdown>tables</td><td markdown>[`\r`](syscmds.md#r-rename)</td><td markdown>rename</td></tr>
<tr markdown><td markdown>[`-b`](cmdline.md#-b-blocked)</td><td markdown>blocked</td><td markdown>[`-s`](cmdline.md#-s-secondary-threads) [`\s`](syscmds.md#s-number-of-secondary-threads)</td><td markdown>secondary processes</td></tr>
<tr markdown><td markdown>[`\b`](syscmds.md#b-views) [`\B`](syscmds.md#b-pending-views)</td><td markdown>views</td><td markdown>[`-S`](cmdline.md#-s-random-seed) [`\S`](syscmds.md#s-random-seed)</td><td markdown>random seed</td></tr>
<tr markdown><td markdown>[`-c`](cmdline.md#-c-console-size) [`\c`](syscmds.md#c-console-size)</td><td markdown>console size</td><td markdown>[`-t`](cmdline.md#-t-timer-ticks) [`\t`](syscmds.md#t-timer)</td><td markdown>timer ticks</td></tr>
<tr markdown><td markdown>[`-C`](cmdline.md#-c-http-size) [`\C`](syscmds.md#c-http-size)</td><td markdown>HTTP size</td><td markdown>[`\ts`](syscmds.md#ts-time-and-space)</td><td markdown>time and space</td></tr>
<tr markdown><td markdown>[`\cd`](syscmds.md#cd-change-directory)</td><td markdown>change directory</td><td markdown>[`-T`](cmdline.md#-t-timeout) [`\T`](syscmds.md#t-timeout)</td><td markdown>timeout</td></tr>
<tr markdown><td markdown>[`\d`](syscmds.md#d-directory)</td><td markdown>directory</td><td markdown>[`-u`](cmdline.md#-u-usr-pwd-local) [`-U`](cmdline.md#-u-usr-pwd) [`\u`](syscmds.md#u-reload-user-password-file)</td><td markdown>usr-pwd</td></tr>
<tr markdown><td markdown>[`-e`](cmdline.md#-e-error-traps) [`\e`](syscmds.md#e-error-trap-clients)</td><td markdown>error traps</td><td markdown>[`-u`](cmdline.md#-u-disable-syscmds)</td><td markdown>disable syscmds</td></tr>
<tr markdown><td markdown>[`-E`](cmdline.md#-e-tls-server-mode) [`\E`](syscmds.md#e-tls-server-mode)</td><td markdown>TLS server mode</td><td markdown>[`\v`](syscmds.md#v-variables)</td><td markdown>variables</td></tr>
<tr markdown><td markdown>[`\f`](syscmds.md#f-functions)</td><td markdown>functions</td><td markdown>[`-w`](cmdline.md#-w-workspace) [`\w`](syscmds.md#w-workspace)</td><td markdown>memory</td></tr>
<tr markdown><td markdown>[`-g`](cmdline.md#-g-garbage-collection) [`\g`](syscmds.md#g-garbage-collection-mode)</td><td markdown>garbage collection</td><td markdown>[`-W`](cmdline.md#-w-start-week) [`\W`](syscmds.md#w-week-offset)</td><td markdown>week offset</td></tr>
<tr markdown><td markdown>[`\l`](syscmds.md#l-load-file-or-directory)</td><td markdown>load file or directory</td><td markdown>[`\x`](syscmds.md#x-expunge)</td><td markdown>expunge</td></tr>
<tr markdown><td markdown>[`-l`](cmdline.md#-l-log-updates) [`-L`](cmdline.md#-l-log-sync)</td><td markdown>log sync</td><td markdown>[`-z`](cmdline.md#-z-date-format) [`\z`](syscmds.md#z-date-parsing)</td><td markdown>date format</td></tr>
<tr markdown><td markdown>[`-o`](cmdline.md#-o-utc-offset) [`\o`](syscmds.md#o-offset-from-utc)</td><td markdown>UTC offset</td><td markdown>[`\1` `\2`](syscmds.md#1-2-redirect)</td><td markdown>redirect</td></tr>
<tr markdown><td markdown>[`-p`](cmdline.md#-p-listening-port) [`\p`](syscmds.md#p-listening-port)</td><td markdown>listening port</td><td markdown>[`\_`](syscmds.md#_-hide-q-code)</td><td markdown>hide q code</td></tr>
<tr markdown><td markdown>[`-P`](cmdline.md#-p-display-precision) [`\P`](syscmds.md#p-precision)</td><td markdown>display precision</td><td markdown>[`\`](syscmds.md#terminate)</td><td markdown>terminate</td></tr>
<tr markdown><td markdown>[`-q`](cmdline.md#-q-quiet-mode)</td><td markdown>quiet mode</td><td markdown>[`\`](syscmds.md#toggle-qk)</td><td markdown>toggle q/k</td></tr>
<tr markdown><td markdown>[`-r`](cmdline.md#-r-replicate) [`\r`](syscmds.md#r-replication-primary)</td><td markdown>replicate</td><td markdown>[`\\`](syscmds.md#quit)</td><td markdown>quit</td></tr>
</table>

[`system`](system.md)


[Command-line options](cmdline.md),
[System commands](syscmds.md),
[OS commands](syscmds.md#os-commands)

<!--
## Environment variables

<table class="kx-tight">
<thead><tr markdown><th>var</th><th>default</th><th>use</th></tr></thead>
<tbody>
<tr markdown><td markdown><code>QHOME</code></td><td markdown><code>$HOME/q</code></td><td markdown>folder searched for q.k and unqualified script names</td></tr>
<tr markdown><td markdown><code>QLIC</code></td><td markdown><code>$HOME</code></td><td markdown>folder searched for k4.lic license file</td></tr>
<tr markdown><td markdown><code>QINIT</code></td><td markdown><code>q.q</code></td><td markdown>additional file loaded after q.k has initialised</td></tr>
<tr markdown><td markdown><code>LINES</code></td><td markdown/><td markdown>supplied by OS, used to set <code>\c</code></td></tr>
<tr markdown><td markdown><code>COLUMNS</code></td><td markdown/><td markdown><code>\c $LINES $COLUMNS</code></td></tr>
</tbody>
</table>

If not set, `LINES COLUMNS` default to 25 80 for console, and 36 2000 for Web. `\c` [clamps](https://en.wikipedia.org/wiki/Clamping_(graphics) "wikipedia definition") to range 10…2000 for both inputs.

Ensure `LINES` and `COLUMNS` are exported. In Bash
```bash
$ export LINES COLUMNS
```
before starting q.
```q
q)getenv`VARNAME
q)`VARNAME setenv "NEWVALUE"
```
 -->

## [Datatypes](datatypes.md)


**Basic datatypes**
n   c   name      sz  literal            null inf SQL       Java      .Net
\------------------------------------------------------------------------------------
0   *   list
1   b   boolean   1   0b                                    Boolean   boolean
2   g   guid      16                     0Ng                UUID      GUID
4   x   byte      1   0x00                                  Byte      byte
5   h   short     2   0h                 0Nh  0Wh smallint  Short     int16
6   i   int       4   0i                 0Ni  0Wi int       Integer   int32
7   j   long      8   0j                 0Nj  0Wj bigint    Long      int64
                      0                  0N   0W
8   e   real      4   0e                 0Ne  0We real      Float     single
9   f   float     8   0.0                0n   0w  float     Double    double
                      0f                 0Nf
10  c   char      1   " "                " "                Character char
11  s   symbol        \`                  \`        varchar
12  p   timestamp 8   dateDtimespan      0Np  0Wp           Timestamp DateTime (RW)
13  m   month     4   2000.01m           0Nm
14  d   date      4   2000.01.01         0Nd  0Wd date      Date
15  z   datetime  8   dateTtime          0Nz  0wz timestamp Timestamp DateTime (RO)
16  n   timespan  8   00:00:00.000000000 0Nn  0Wn           Timespan  TimeSpan
17  u   minute    4   00:00              0Nu  0Wu
18  v   second    4   00:00:00           0Nv  0Wv
19  t   time      4   00:00:00.000       0Nt  0Wt time      Time      TimeSpan

Columns:
_n_    short int returned by [`type`](type.md) and used for [Cast](cast.md), e.g. `9h$3`
_c_    character used lower-case for [Cast](cast.md) and upper-case for [Tok](tok.md) and [Load CSV](file-text.md#load-csv)
_sz_   size in bytes
_inf_  infinity (no math on temporal types); an integer infinity is the largest representable value of its type

RO: read only; RW: read-write

**Other datatypes**
20-76   enums
77      anymap                                      104  [projection](application.md#projection)
78-96   77+t – mapped list of lists (legacy)        105  [composition](compose.md)
97      nested sym enum (legacy)                    106  [f'](maps.md#each)
98      table                                       107  [f/](accumulators.md)
99      dictionary                                  108  [f\\](accumulators.md)
100     [lambda](function-notation.md)                                      109  [f':](maps.md)
101     unary primitive                             110  [f/:](maps.md#each-left-and-each-right)
102     operator                                    111  [f\\:](maps.md#each-left-and-each-right)
103     [iterator](iterators.md)                                    112  [dynamic load](dynamic-load.md)


Above, `f` is an [applicable value](glossary.md#applicable-value).

Nested types are 77+t (e.g. 78 is boolean. 96 is time.) These are legacy: KDB-X writes `anymap` (77) instead. See [Datatypes](datatypes.md#nested-types).

[Cast `$`](cast.md): where `char` is from the `c` column above `char$data:CHAR$string`
```txt
dict:`a`b!…
table:([]x:…;y:…)
date.(year month week mm dd)
time.(minute second mm ss)
milliseconds: time mod 1000
```

## Namespaces

### [`.h`](doth.md) (markup)

HTTP, markup and data conversion.

### [`.j`](dotj.md) (JSON)

De/serialize as JSON.

### [`.m`](dotm.md) (modules)

The currently loaded modules. The meaning of `.m` has changed between kdb+ versions.

### [`.Q`](dotq.md) (utils)

Utilities: general, environment, IPC, datatype, database, partitioned database state, segmented database state, file I/O, debugging, profiling.

### [`.z`](dotz.md) (environment, callbacks)

Environment, callbacks
