System Tables

These tables provide easy to work with, low-overhead tables for building Macro Language queries where no specific data is required.

Description

These tables can be invoked using the <base> operation:

<base table="default.lonely"/>

For default.empty, the <meta> tag must be used, because by default 1010data will issue an error when a table has no rows or no rows are selected. To use default.empty, enter the following code:

<meta>empty</meta>
<base table="default.empty"/>

<base table=session.tables"/>

System tables

Table 1. System tables
Table name	Description
`default.lonely`	Provides a table with one column and one row. The column name is `c1`, and the value of the first row of `c1` is `1`.
`default.empty`	Provides an empty table with one column. The column name is `c1`, and the column contains no values.
`default.test.json`	Contains columns with various JSON payloads as strings, permitting easier experimentation with both JSON and (via `dejson()`) packages in a vector context. Note: The contents of `default.test.json` may change over time. (Available as of version 15.01)
`session.tables`	Shows all DBM objects a user can see. Note: Do not use `session.tables` in production code.