MSSQL (version 1.0.1)

dbTime: Time Created and Modified

Description

Get time information about tables and views: when they were created and when they were last modified.

Usage

dbTime(channel)

Value

Data frame containing five columns:

Name

name of table/view.

Schema

database schema.

Type

type of table/view.

Created

time created.

Modified

time last modified.

Arguments

channel

an RODBC connection.

See Also

sqlQuery is the underlying function used to query sys.tables and sys.views.

dbOverview shows the dimensions of tables/views and the first column names, and dbStorage shows the storage size of tables.

Sys.time is the base function to show the current time.

MSSQL-package gives an overview of the package.

Examples

if (FALSE) {
con <- odbcConnect("myDatabase")

dbTime(con)
}