{"action":"created","issue":{"url":"https://api.github.com/repos/r-dbi/DBI/issues/244","repository_url":"https://api.github.com/repos/r-dbi/DBI","labels_url":"https://api.github.com/repos/r-dbi/DBI/issues/244/labels{/name}","comments_url":"https://api.github.com/repos/r-dbi/DBI/issues/244/comments","events_url":"https://api.github.com/repos/r-dbi/DBI/issues/244/events","html_url":"https://github.com/r-dbi/DBI/issues/244","id":320885288,"node_id":"MDU6SXNzdWUzMjA4ODUyODg=","number":244,"title":"Have synonyms show-up for Microsoft SQL Server `dbListTables`","user":{"login":"brshallo","id":30487784,"node_id":"MDQ6VXNlcjMwNDg3Nzg0","avatar_url":"https://avatars0.githubusercontent.com/u/30487784?v=4","gravatar_id":"","url":"https://api.github.com/users/brshallo","html_url":"https://github.com/brshallo","followers_url":"https://api.github.com/users/brshallo/followers","following_url":"https://api.github.com/users/brshallo/following{/other_user}","gists_url":"https://api.github.com/users/brshallo/gists{/gist_id}","starred_url":"https://api.github.com/users/brshallo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/brshallo/subscriptions","organizations_url":"https://api.github.com/users/brshallo/orgs","repos_url":"https://api.github.com/users/brshallo/repos","events_url":"https://api.github.com/users/brshallo/events{/privacy}","received_events_url":"https://api.github.com/users/brshallo/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-05-07T17:21:14Z","updated_at":"2018-08-06T14:25:18Z","closed_at":null,"author_association":"NONE","body":"I regularly connect to data marts provisioned for me on Microsoft SQL Server.\r\n\r\nWhen connecting to Microsoft SQL Server, the RStudio \"Connections\" tab shows \"tables\" and \"views\" but does not show \"synonyms\".  (\"Synonyms\" also do not show-up when running `DBI::dbListTables(con)`)\r\n\r\nIf I want to view the synonyms in R I will typically do something like:\r\n\r\n```\r\nlibrary(tidyverse)\r\nxtypes <- c(\"V\", \"SN\", \"U\")\r\ntables_access <- tbl(con, \"sysobjects\") %>% \r\n  select(name, xtype) %>% \r\n  collect() %>%\r\n  filter(str_detect(xtype, \"V|SN|U\"))\r\n\r\nView(tables_access)\r\n```\r\n\r\nThough this is less convenient.  The ability to connect and query synonyms is unaffected.  Only the ability to preview tables via `DBI::dbListTables` / the Connections tab, and only for Microsoft SQL Server.  \r\n\r\nRight now I end-up usually using Tableau's data previewer in parallel (which I believe is using the same driver but defaults to show synonyms as well as views and tables)...\r\n\r\nIf it does not make sense to have synonyms show-up by default in the package, do you know what change to options i can make that would make 'synonyms' show-up in my 'Connections' pane in RStudio when connecting to Databases on Microsoft SQL Server?\r\n\r\n### System details\r\n    RStudio Edition : Desktop\r\n    RStudio Version :  1.1.282\r\n    OS Version      :  Windows 10 Enterprise, x64-based processor\r\n    R Version       :  R version 3.4.2 (2017-09-28)\r\n\r\n### Packages:\r\n    dbi pacakge version: 0.8\r\n    driver: \"SQL Server\"\r\nThe same thing occurs whether I'm connecting via windows authentication or with a specific username and password with odbc.  The lack of synonyms showing-up when running `DBI::dbListTables` also occurs whether I'm using odbc or RJDBC for connecting."},"comment":{"url":"https://api.github.com/repos/r-dbi/DBI/issues/comments/410726207","html_url":"https://github.com/r-dbi/DBI/issues/244#issuecomment-410726207","issue_url":"https://api.github.com/repos/r-dbi/DBI/issues/244","id":410726207,"node_id":"MDEyOklzc3VlQ29tbWVudDQxMDcyNjIwNw==","user":{"login":"brshallo","id":30487784,"node_id":"MDQ6VXNlcjMwNDg3Nzg0","avatar_url":"https://avatars0.githubusercontent.com/u/30487784?v=4","gravatar_id":"","url":"https://api.github.com/users/brshallo","html_url":"https://github.com/brshallo","followers_url":"https://api.github.com/users/brshallo/followers","following_url":"https://api.github.com/users/brshallo/following{/other_user}","gists_url":"https://api.github.com/users/brshallo/gists{/gist_id}","starred_url":"https://api.github.com/users/brshallo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/brshallo/subscriptions","organizations_url":"https://api.github.com/users/brshallo/orgs","repos_url":"https://api.github.com/users/brshallo/repos","events_url":"https://api.github.com/users/brshallo/events{/privacy}","received_events_url":"https://api.github.com/users/brshallo/received_events","type":"User","site_admin":false},"created_at":"2018-08-06T14:25:18Z","updated_at":"2018-08-06T14:25:18Z","author_association":"NONE","body":"Would this be more appropriate under `odbc` as this is what currently drives the [viewer](https://github.com/r-dbi/odbc/blob/b719c47d129b598712575618ed5f40df5b813d4b/R/Viewer.R)?"}}
{"actor":{"display_login":"brshallo"}}