spec_sql_list_fields
dbListFields()
returns a character vector
that enumerates all fields
in the table in the correct order.
This also works for temporary tables if supported by the database.
The returned names are suitable for quoting with dbQuoteIdentifier().
If the table does not exist, an error is raised.
Invalid types for the name argument
(e.g., character of length not equal to one,
or numeric)
lead to an error.
An error is also raised when calling this method for a closed
or invalid connection.
The name argument can be
a string
the return value of DBI::dbQuoteIdentifier()
a value from the table column from the return value of
DBI::dbListObjects() where is_prefix is FALSE
A column named row_names is treated like any other column.
Other sql specifications:
spec_sql_append_table,
spec_sql_create_table,
spec_sql_exists_table,
spec_sql_list_objects,
spec_sql_list_tables,
spec_sql_quote_identifier,
spec_sql_quote_literal,
spec_sql_quote_string,
spec_sql_read_table,
spec_sql_remove_table,
spec_sql_unquote_identifier,
spec_sql_write_table