get_DB_info: Get database info
In martinkabe/RSQLS: Package for interactive work with SQL Server
Description
Usage
Arguments
Value
Note
Examples
Description
This function retrieves basic info about database defined
in SQL Server connection string.
Usage
1
get_DB_info(connectionString)
Arguments
connectionString
Connection string to SQL server.
Value
Returns data.frame and data.table object.
Note
How to set up SQL Server connection string see set_connString. Be also sure you have a permissions for access to sys.dm_db_index_usage_stats:
check it with SELECT * FROM sys.dm_db_index_usage_stats. If not, contact your SQL Server admin.
Examples
1
2
3
4
## Not run:
get_DB_info(connectionString)
## End(Not run)
martinkabe/RSQLS documentation built on June 19, 2020, 8:47 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments Value Note Examples
Description
This function retrieves basic info about database defined in SQL Server connection string.
Usage
1 | get_DB_info(connectionString)
|
Arguments
connectionString |
Connection string to SQL server. |
Value
Returns data.frame and data.table object.
Note
How to set up SQL Server connection string see set_connString. Be also sure you have a permissions for access to sys.dm_db_index_usage_stats: check it with SELECT * FROM sys.dm_db_index_usage_stats. If not, contact your SQL Server admin.
Examples
1 2 3 4 | ## Not run:
get_DB_info(connectionString)
## End(Not run)
|
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.