How to get the schema of a database with the DBI package

Question

Is there a function in the DBI package to get information about the schema of a database?

I am working with a connection to an SQL Server with the DBI package and the odbc driver. The dbListTables functions allows to show the tables in a particular schema with the schema parameter, but I cannot find a way to query which schemas there are.

score 6 · Accepted Answer · edited Jun 17 '18 at 16:56

6

You could use the SQL query below.

all_schemas <- DBI::dbGetQuery(conn, "SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA")

edited Jun 17 '18 at 16:56

Jonathan Leffler

730,956
141
904
1,278

answered May 29 '17 at 21:12

qfazille

1,643
13
27

1

DBI::dbListObjects(conn) lists the schemata. – sdittmar Nov 01 '18 at 09:36
2

DBI::dbListObjects(conn, Id(schema = "mySchemaName")) lists a specific schema. – sdittmar Nov 01 '18 at 09:42

How to get the schema of a database with the DBI package

1 Answers1