dbTime function

Time Created and Modified

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

dbTime(channel)

Arguments

• channel: an RODBC connection.

Returns

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.

Examples

## Not run:

con <- odbcConnect("myDatabase")

dbTime(con)
## End(Not run)

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.