csql

View a <code>dbi.table</code>'s underlying SQL query.

Query database tables over a 'DBI' connection using 'data.table' syntax.
Attach database schemas to the search path. Automatically merge using foreign
key constraints.

Kjell Konis

dbi.table

Database Queries Using 'data.table' Syntax

Luis Rocha

csql function

<dl><dt>x</dt>
<dd>a <code>dbi.table</code>.</dd>
<dt>n</dt>
<dd>a single integer value. When nonnegative, limits the number of rows
returned by the query to <code>n</code>.</dd>
<dt>strict</dt>
<dd>a logical value. If <code>TRUE</code> and <code>x</code> has a key, the key is
appended to the ORDER BY clause.</dd></dl>

Arguments

See SQL — csql

<dl>

<dt>x</dt>
<dd>a <code>dbi.table</code>.</dd>


<dt>n</dt>
<dd>a single integer value. When nonnegative, limits the number of rows
returned by the query to <code>n</code>.</dd>


<dt>strict</dt>
<dd>a logical value. If <code>TRUE</code> and <code>x</code> has a key, the key is
appended to the ORDER BY clause.</dd>

</dl>

csql: See SQL

Description

Usage

Value

Arguments