odbcListObjects function

List objects in a connection.

Lists all of the objects in the connection, or all the objects which have specific attributes.

odbcListObjects(connection, ...)

Arguments

• connection: A connection object, as returned by dbConnect().
• ...: Attributes to filter by.

Returns

A data frame with name and type columns, listing the objects.

Details

When used without parameters, this function returns all of the objects known by the connection. Any parameters passed will filter the list to only objects which have the given attributes; for instance, passing schema = "foo"

will return only objects matching the schema foo.