odbcConnectionColumns {odbc} | R Documentation |
For a given table this function returns detailed information on
all fields / columns. The expectation is that this is a relatively thin
wrapper around the ODBC SQLColumns
function call, with some of the field names
renamed / re-ordered according to the return specifications below.
odbcConnectionColumns(conn, name, ...) ## S4 method for signature 'OdbcConnection,Id' odbcConnectionColumns(conn, name, column_name = NULL) ## S4 method for signature 'OdbcConnection,character' odbcConnectionColumns( conn, name, catalog_name = NULL, schema_name = NULL, column_name = NULL )
conn |
OdbcConnection |
name |
table we wish to get information on |
... |
additional parameters to methods |
column_name |
The name of the column to return, the default returns all columns. |
catalog_name |
character catalog where the table is located |
schema_name |
character schema where the table is located |
In dbWriteTable()
we make a call to this method
to get details on the fields of the table we are writing to. In particular
the columns data_type
, column_size
, and decimal_digits
are used. An
implementation is not necessary for dbWriteTable()
to work.
data.frame with columns
name
field.type - equivalent to type_name in SQLColumns output
table_name
schema_name
catalog_name
data_type
column_size
buffer_length
decimal_digits
numeric_precision_radix
column_default
sql_data_type
sql_datetime_subtype
char_octet_length
ordinal_position
nullable
The ODBC documentation on SQLColumns for further details.