dbTime {MSSQL}

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)

Arguments

channel

an RODBC connection.

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.

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

## Not run: 
con <- odbcConnect("myDatabase")

dbTime(con)

## End(Not run)