odbcPreviewQuery: Create a preview query.

In odbc: Connect to ODBC Compatible Databases (using the DBI Interface)

Create a preview query.

Description

Optimize against the rowLimit argument. S3 since some back-ends do not parse the LIMIT syntax. Internal, not expected that users would interact with this method.

Usage

odbcPreviewQuery(connection, rowLimit, name)

## S3 method for class 'OdbcConnection'
odbcPreviewQuery(connection, rowLimit, name)

## S3 method for class ''Microsoft SQL Server''
odbcPreviewQuery(connection, rowLimit, name)

## S3 method for class 'Teradata'
odbcPreviewQuery(connection, rowLimit, name)

## S3 method for class 'Oracle'
odbcPreviewQuery(connection, rowLimit, name)

Arguments

connection	A connection object, as returned by dbConnect().
rowLimit	The maximum number of rows to display.
name	Name of the object to be previewed

odbc documentation built on June 22, 2024, 9:47 a.m.